Spreadsheet help
-
crazyWarr
- NewLounger
- Posts: 1
- Joined: 05 Apr 2024, 07:42
Spreadsheet help
Hi. I would like to make a spreadsheet that will calculate a $100,000 investment that will make 4.3% APY interest with a $4,500 a month withdrawal. How much will be left after one year? Anyone?
-
HansV
- Administrator
- Posts: 78565
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Spreadsheet help
Welcome to Eileen's Lounge!
You can use the FV function for this purpose:
The formula in B5 is:
=FV(B2/12,B4,B3,B1)
You can use the FV function for this purpose:
The formula in B5 is:
=FV(B2/12,B4,B3,B1)
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans