Spreadsheet help

crazyWarr
NewLounger
Posts: 1
Joined: 05 Apr 2024, 07:42

Spreadsheet help

Post by crazyWarr »

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?

User avatar
HansV
Administrator
Posts: 79543
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Spreadsheet help

Post by HansV »

Welcome to Eileen's Lounge!
You can use the FV function for this purpose:

S2545.png

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