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
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
Get step-by-step solutions from verified subject matter experts
