Question: !!!!!!ONLY ANSWER USING EXCEL PLEASE!!!!!! 4 You are financing a new home. 5 The loan is for $191,000 and you are getting rate of 4.1%

!!!!!!ONLY ANSWER USING EXCEL PLEASE!!!!!!

4 You are financing a new home. 5 The loan is for $191,000 and you are getting rate of 4.1% per year. 56 You have decided on a 15 year mortgage and will make monthly payments (end of the month). 57 To get the ball roling, you are working extra hours and expect to pay an extra $410 per month to knock down the principle. 58 You make these payments for 4 years starting on month 1. The last payment is on month 48. 69 70 Build the amortization table. 71 What month will you make your last payment? 72 How much will the last payment be? 79 74 Problems 16 Points

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 Accounting Questions!

Scenario: You are financing a new home. Your mortgage loan is on $236,000 at 3.5% fixed APR for a period of 30 years. You are provided an amortization schedule which shows the amount of principal and...

Savings Plans and Investments/Loan Payments, Credit Cards, and Mortgages Please work through the following items. For questions referencing items online, please do a general search using your laptop,...

Old MathJax webview T U ASSIGNMENT 1: CAPITAL BUDGETING ABC LTD BALANCE SHEETS AS AT 31 DECEMBER ($000) 2015 2016 2017 2018 2015 2016 2017 2018 ASSETS Current Assets Cash Account Receivable Inventory...

Hello, Need help with the following:Please see Rubric thks Using information from"Are You Paying Too Much for That Acquisition?" List and describe the components used to calculate synergy value....

ABC LTD BALANCE SHEETS AS AT 31 DECEMBER ($000) 2015 2016 2017 2018 2015 2016 2017 2018 ASSETS Current Assets Cash Account Receivable Inventory Prepaid Expense Total Current Assets 515 106 212 22 855...

Directions for Problem #4 in Excel The goal of this problem is to have you: Use Excel to generate the future value of each of the various investments made over the course of the 25 years. Use Excel...

Answer in excel, please. Problem Set #2 Fixed Payment Loan Calculation You are looking to buy a new Ford F150. The "all in out the door" price comes to $56,000. The dealer gives you two options for...

Please answer the question of the yellow cell, and write out the steps if you can. Chez Guevara Java for the Revolution You have developed a chain of 20 cyber cafs with a gross margin of 80%. You...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

solve the given problem question A B and C in the given detail using excel. please provide complete solution for all questions Tiffany owns an event management business that is currently operating...

Consider the wave function y (0, 9) = 3 sin 0 cos Oe-2(1 cos 0)e2ie. %3D (a) Write w (0, ) in terms of the spherical harmonics. (b) Write the expression found in (a) in terms of the Cartesian...

This table gives the results of the J.D. Power initial quality study of 2006 automobiles. Each model is rated on overall manufacturing quality and overall design quality on a scale from among the...

Which of the following usually results in an increase in a deferred tax liability? 0 . 8 pointsMultiple Choice 0 1 : 1 5 : 4 4 Accrual of estimated operating expensesRevenue collected in...

Select all that apply The formula for the weighted mean is X w=(wX)w Which of the following statements are true of the weighted mean? Select all that apply. Multiple select question. It gives a...

Review Figure 16.9, a scannable rsum illustrated in this chapter, and make a list of words that you believe to be keywords related to property management and marketing. (Objective 4)

Ethics. Teamwork. Technology. Read the scenario below; partner with a classmate to discuss the ethical questions following the scenario.Working together, write an e-mail to your instructor explaining...

Technology. Access job opportunities on the Internet for positions related to your career objective. Assess the job opportunities in terms of your interest in them.Write a letter to your instructor...