need help on this question excel spread sheet is attached

Name Class Id Section E-Mail Address Score 0/100 Problem Problem 3 Answer a b c d e f g Old New Old New Old New Correct Answer Score 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0000 Bonus Total Score 0.0 Full Comments Score 10 10 10 10 10 10 10 10 10 10 100 Sheet Name P3 P3 P3 P3 P3 P3 P3 P3 P3 P3 Sub Q. No. 1 2 3 4 5 6 7 8 9 10 $D:$G LinkAns Problem 1 Intial Loan Amount $475,000 annual rate Before refinancing (old loan) time loan outstanding refinancing Loan monthly rate Nper 0.67% 8.00% new annual rate new monthly rate 0.63% 84 7.50% Part A Old Part C New Amounts Rate Nprd Payment time outstanding Balance (of old loan) at refinancing Cost of new loan Amount of New Loan Period Current-ending prd Rate Nprd Payment Pv Old - New Loan Moving Options Nprd from current to moving 84 Part D Old New Part F Year Months 7 84.00 Old New Part G Year Months balance at the time of Moving Pv of Moving Choice Old - New Loan Moving Options 240 Nprd from current to moving 7.00 84.00 Rate Changing Cell Old New Rate Nprd Month Payment balance at the time of Moving Pv of Moving Choice Old - New Loan Set Cell Goal Seek JMALM: cost of refinancing new nper $5,075 Suppose you purcha year mortgage with 7.5% at a cost $5,07 a. What is the month b. How much would c. Suppose that you cost of refinancing. would be the monthl d. When we assume present values of bo e. Suppose that you balance of both loan f. If you expected to and new loan? g. If you expected to what would be the o rate that will make th 240 Part B Balance of Old Loan Now Loan Amounts Int. Rate Nprd Starting Prd Ending Prd Balance at current period Part E Balance of Old Loan at the time of moving Loan Amounts Int. Rate Nprd Starting Prd Ending Prd Balance at current period Balance of Old Loan at the time of moving Loan Amounts Int. Rate Nprd Starting Prd Ending Prd Balance at current period JMALM: Suppose you purchased a house 7 years ago and took out an 8%, $475,000, 20 year mortgage with monthly payments. Today you can refinance the loan at 7.5% at a cost $5,075. a. What is the monthly payment of your old loan? b. How much would you still owe on the loan now? c. Suppose that you would only refinance enough to repay the old loan and the cost of refinancing. If you would take a 20 years loan at the new rate, what would be the monthly payments of your new loan? d. When we assume that two loans are held until maturity, what are the present values of both old and new loan? e. Suppose that you plan to move in 7 years. Then, what would be the ending balance of both loans at the time of moving? f. If you expected to move in 7 years, what are the present values of both old and new loan? g. If you expected to move in 7 years and the refinancing has no advantage, what would be the opportunity cost of the new loan? That is, find the interest rate that will make the difference between the two equal to zero. Balance of New Loan at the time of moving Loan Amounts Int. Rate Nprd Starting Prd Ending Prd Balance at current period Balance of New Loan at the time of moving Loan Amounts Int. Rate Nprd Starting Prd Ending Prd Balance at current period , $475,000, 20 e the loan at d loan and the rate, what are the be the ending s of both old advantage, d the interest