Question: 2. (15 pts.) Make an Excel spreadsheet (sheet 2, renamed as FVA) which a label across the top of monthly contributions are columns, length of
2. (15 pts.) Make an Excel spreadsheet (sheet 2, renamed as FVA) which a label across the top of monthly contributions are columns, length of months are rows, table assumes 7% APR. Then have columns headed with $50, $100, $150, $200, etc., up to and including $1,000. Also have corresponding rows labelled 10 months, 20 months, 30 months, etc., up to and including 400 months. Fill the table with the resulting ending balance amounts, so the top-left table amount is the account balance the moment after making the 10th deposit of $50 into an account growing at 7% APR compounded monthly.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
