Problem # 4 Fill in the loan analysis table to get the values in the shaded cells. (8) A. Row 6: The shaded cell in row 6 tells you the payment required to pay down a loan to $ 100,000 if paid periodically for 5 years. B. Row 7: The shaded cell in row 7 tells you how much of the loan you have left to pay (FV) if you make a periodic payment for 5 years. Assume that you make a $ 22,000 payment each period. C. Row 8: The shaded cells in row 8 tells the number of payments (and years) needed to pay off a loan if you make a $ 20,000 payment each period. D. Row 9: The shaded cell in row 9 tells you how much you could afford to borrow if you make periodic payments for 5 years to be able to pay off the loan at the end of the 5-year period, Assume that you make a $ 18,500 payment cach period for 5 years. PV FV $30,000 $40,000 $40,000 N (years) interest rate 5 0.05 8 0.15 9 0.075 in CO FV PV $3,000 $50,000 $20,000 Nyears) interest rate 4 0.1 8 0.6 14 0.75 00 PV FV $25,000 $35,000 $45,000 N(years) interest rate 6 0.025 12 0.03 15 0.05 2 FV PV $1,800 $2,600 $3,500 N (years) interest rate 10 0.08 6 0.04 8 0.06