Question: That table showing the monthly payment that will allow Dave and Jana to pay off the loan in 12 years, 11 years and 10 years

That table showing the monthly payment that will allow Dave and Jana to pay off the loan in 12 years, 11 years and 10 years ( additional payment column). Base on those payments, which option for prepayment if any, would you choose and why?

That table showing the monthly payment that will allow Dave and Jana

1 Dave and Jana's Mortgage Refinance Problem Parameters $208,555.87 3.90% 5 Amount Borrowed Annual Interest Rate 7 Number of Years 8 Monthly Payment 9 Additional Monthly Payment $1,532.23 $283.62 Payment Number Additional Payment 10 Years 11 Years 12 Years S569.40 S413.321 S283.62 10 12 13 14 15 16 17 Planned Payment $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 $1,532.23 Interest $677.81 S674.11 S670.40 S666.67 S662.94 $659.19 $655.43 $651.66 $647.88 S644.08 $640.27 S636.45 $632.62 S628.78 $624.92 S621.05 $617.16 $613.27 $609.36 $605.44 $601.50 $597.56 $593.60 S589.63 S585.64 $581.64 Principal $854.43 5858.12 S861.83 5865.56 $869.29 $873.04 $876.80 S880.57 $884.35 $888.15 $891.96 $895.78 $899.61 $903.46 $907.31 S911.19 S915.07 S918.96 $922.87 S926.79 S930.73 $934.67 $938.63 $942.61 S946.59 $950.59 Additional Payment $283.62 $283.62 $283.62 S283.62 $283.62 S283.62 $283.62 S283.62 $283.62 S283.62 $283.62 S283.62 S283.62 S283.62 $283.62 S283.62 $283.62 S283.62 $283.62 S283.62 S283.62 S283.62 $283.62 S283.62 $283.62 $283.62 Previous Balance $208,555.87 $207,417.83 $206,276.08 $205,130.63 $203,981.45 $202,828.54 $201.671.88 S200,511.46 $199,347.27 $198,179.30 $197,007.53 $195,831.95 $194,652.55 $193,469.32 $192,282.24 $191,091.31 $189,896.50 $188,697.81 $187,495.23 $186,288.73 $185,078.32 $183,863.97 $182,645.68 $181,423.43 $180,197.20 $178,966.99 Ending Balance $207,417.83 $206,276.08 $205,130.63 $203,981.45 $202,828.54 $201.671.88 $200,511.46 $199,347.27 $198,179.30 $197,007.53 $195,831.95 $194,652.55 $193,469.32 $192,282.24 $191,091.31 $189,896.50 $188,697.81 $187,495.23 $186,288.73 $185,078.32 $183,863.97 $182,645.68 $181,423.43 $180,197.20 $178,966.99 $177,732.78 18 19 20 22 24

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

here is the full question you can use for reference (c) Demonstrate in a Data Table how the Monthly Payment will be affected by the "Number of pay back years and Down payment (% of Selling Price)"....

8.1 Loan Calculations | Terry wants to purchase a used car for $8,000. The dealer has offered to finance the deal at 8.5% APR for four years with a 10% down payment. Terry's bank will provide a loan...

YO16_XL_GRADER_CASE5 - Coffee 1.1 Project Description: Chloe Jants is fulfilling her long-term dream of opening a coffee shop on a busy corner of her hometown. Her town is like many others in the...

Hey please I just need you to show steps like how to do them because I dont know how to do it. PLEASE EXPLAIN LIKE YOURE EXPLAINING TO SOMEONE WHO NEVER USED EXCEL THANKS. STEPS 2-31. Step...

These are screenshots of the workbook. These are the instructions. Please solve step by step with screenshots! AutoSave OFF BESU- Page Layout Formulas Cooper_Exp 19_Excel_Ch07_CapAssess Data Review...

Problem Statement Design and implement a Graphical User Interface (GUI) application that computes auto loan payments. The developed GUI allows a user to compute monthly loan payments interactively...

PLEASE ENTER ANSWERS IN BLUE BOLD INK! Ann wants a mortgage to buy a house. Ann gives the following information to the bank: Income: $240k/year or 20k/month Average monthly debt: $2k Estimated...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

Excel Lab 3: Financial Mathematics Open a blank Excel sheet and put your name in cell A1 of each worksheet. Problem 1 (Sheet 1) In this problem we will investigate monthly payments on a loan by using...

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

With reference to the previous problem, determine the reduction in diameter of the liner when the liner first fails. Discuss.

For a sum of money invested at 10% compounded quarterly for 12 years, state (a) The nominal annual rate of interest (j); (b) The number of compounding periods per year (m); (c) The periodic rate of...

Jason believes that a company is going to earn record profits this year, so he wants to buy a few hundred shares of its stock. He would purchase this stock in the _ _ _ _ _ _ _ market. Question...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Distinguish between primary and secondary information sources. Give an example of each. (Objective 3)

Mary Lous Family Cooking has been operating for 25 years. Several chain restaurants have moved into the area resulting in a highly competitive market.Mary Lous currently owes an $18,750 balance for...

While working as part of a research team, one of your coworkers tells you that failing to cite sources doesnt constitute plagiarism if youre writing an internal report. Do you agree or disagree? Why?...