315,000.00 please show excel spreadsheets

4%

SCENARIO 3 . Based on Scenario 1, what happens if you pay an additional $350 per month? 1. How much is your new payment? 2. How much sooner do you finish paying your loan? (in years & months) 3. How much do you save on interest? Scenario 3- Additional Payment/month (5points) New Payment No of Years to Payoff the Loan Total Interest Amount (S) Savings 7 8 315000N 9 10 11 12 13 14 15 16 17 18 Scenario 1 (15 points) Home Value Bank Name Closing Costs Amount Financed Loan Amount (Amount Financed Closing Costs) APR No of Years No of Periods Effective Rate Monthly Rate Monthly Payment How does the payment you calculated compare to the one given by the bank? Total Interest Amount (S) Principal Outstanding half way throught the loan 6300 315,000.00 321,000.00 4% 30 360 0.33% 0.33% $1,503.86 19 20 21 27 $203,309.82 SCENARIO 3 . Based on Scenario 1, what happens if you pay an additional $350 per month? 1. How much is your new payment? 2. How much sooner do you finish paying your loan? (in years & months) 3. How much do you save on interest? Scenario 3- Additional Payment/month (5points) New Payment No of Years to Payoff the Loan Total Interest Amount (S) Savings 7 8 315000N 9 10 11 12 13 14 15 16 17 18 Scenario 1 (15 points) Home Value Bank Name Closing Costs Amount Financed Loan Amount (Amount Financed Closing Costs) APR No of Years No of Periods Effective Rate Monthly Rate Monthly Payment How does the payment you calculated compare to the one given by the bank? Total Interest Amount (S) Principal Outstanding half way throught the loan 6300 315,000.00 321,000.00 4% 30 360 0.33% 0.33% $1,503.86 19 20 21 27 $203,309.82