need formulas in green

Page Layout Formulas Data Rece View Develope Help Power Pivot Tell me what you want to do 12 VAAW Copy" Co I Formatting Tool Annuity Challenger Solve the following three problems in the space provided Do not found any calculations All calculations should result in positive numbers Problem 1: - You plan to buy a home for $220.000 You sign a 30-year mortgage with an APRO 4.6% you were to $100 to each monthly payment how many monthly payments would you actually have to make? $220,000 12 $100 Contractual Monty Payment Actual Monty Payment Problem 2: SERIE You win the NY Lotto and are offered the choice of 20 payments beginning today of $300.000 orang sunday of 20000 Which is the best anal choice? How much more in presente do you can by making the correct choice? The discount rate is 32% 300.000 250.000 PV of Annully Option PV of Lumo Sum Oference in PV Problem Type here to search Problem 3: You are 62 years old today and can take your Social Security payments early or wat until your Fun Rctement Age (FRA) of 67. If you start early, your monthly payments will be $1,700 if you wait until age 67, you'll receive monthly payments of $2.400 in either case your payments will start one month from the date at which you choose to start if the discount rate is 28%, and you expect to live until age 84, what choice should you make. Assume no other factors apply to your decision. Hint, you must find the PV of both options AT age 62 to make a decision 62672 80% $2.4001284 $1.700 Number of monthly payments if taken early Number of monthly payments it taken at FRA PV (at age 62) of payments taken early PV (at age 62) of payments if taken at FRA Choice Find the PV at age 67 then treating that as a lump som find the PV at age 62 student name main rcular References Scroll tack Accessit investigate Type here to search