Question: if you know how to use excel, how do you plug these in to the functions. number 1 uses the PMT function and number 2

if you know how to use excel, how do you plug these in to the functions. number 1 uses the PMT function and number 2 uses the FV function. i am not sure what function for question 3. if you know how to use excel, how do you plug these
in to the functions. number 1 uses the PMT function and number

1. Company ABC has $275,000 in debt it wishes to finance The bank offers 8.30% interest over 30 years. What is Company ABC's monthly payment? Place your answer in cell C10 (2 points) 2. You wish to retire in 40 years. You agree to save $250 per month. You will earn 3 15% on your money. How much will you have at retirement? Place your answer in cell C19 (2 points) 3. Your uncle wishes to purchase your collection of baseball cards. He will pay you $2000 today or $3500 in nix years. Assume a rate of 6% Place your formula with answer in cell C29. Which offer should you take? Explain in one or two sentences beginning cell C30 (2 points) 1 Font Alignment CS X B D 1. Company ABC's monthly Payment G H E show work below 4 5 6 Answer 1 2. Retirement Value - show work below 8 9 10 11 12 3 4 15 16 7 8 9 0 Answer 2 3. Baseball Card Offer -- show work below 2 3 4 5 6 7 Functions Sales Forecast Invoice Twister + inter O Type here to search

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!