In yellow boxes 1,2,3,4,6,7,13 you must have created excel formulas (see cell 15 for example) In...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In yellow boxes 1,2,3,4,6,7,13 you must have created excel formulas (see cell 15 for example) In yellow boxes 5,8, 10 & 11 just type in numbers or words 1. $160000 house is purchased with 5% down payment. The loan payment is monthly at 6% for 20 years. In Excel: calculate find the present value, i, total number of payments,see below. Calculate the payment amount 3 different ways, see below 2. In excel calculate down payment 3.i Mortgage amt PV- Down Payment= i= 4. n=# of pmts 5. Hand calculate mortgage payment pmt= 6. calculate payment with Fx (click on FORMULA click on Financial and scroll to PM pmt= 7. calculate payment with excel formula "-G5" (G10/(1-(1+G10)^-G11))" pmt= 422 8. Give 4 solutions to reduce monthly payment 1 1 2 3 4 9 Use the following web site and input given information. Click box to show amortization table. http://www.bretwhissel.net/cgi-bin/amortize 10. From the web site how much total interest is paid: 11. From web site what is the remaining principle after the first year of payments? 12 Other closing evnences are your attorney $500 bank attorney $500 title $600 donosit for taxes $1200 misc $500 1 =160000-G8 In yellow boxes 1,2,3,4,6,7,13 you must have created excel formulas (see cell 15 for example) In yellow boxes 5,8, 10 & 11 just type in numbers or words 1. $160000 house is purchased with 5% down payment. The loan payment is monthly at 6% for 20 years. In Excel: calculate find the present value, i, total number of payments,see below. Calculate the payment amount 3 different ways, see below 2. In excel calculate down payment 3.i Mortgage amt PV- Down Payment= i= 4. n=# of pmts 5. Hand calculate mortgage payment pmt= 6. calculate payment with Fx (click on FORMULA click on Financial and scroll to PM pmt= 7. calculate payment with excel formula "-G5" (G10/(1-(1+G10)^-G11))" pmt= 422 8. Give 4 solutions to reduce monthly payment 1 1 2 3 4 9 Use the following web site and input given information. Click box to show amortization table. http://www.bretwhissel.net/cgi-bin/amortize 10. From the web site how much total interest is paid: 11. From web site what is the remaining principle after the first year of payments? 12 Other closing evnences are your attorney $500 bank attorney $500 title $600 donosit for taxes $1200 misc $500 1 =160000-G8
Expert Answer:
Answer rating: 100% (QA)
Answer 1 To calculate the present value PV in Excel you can use the formula PV 160000 G8 2 The down ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
A firm is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. The CEO wants to use the IRR criterion, while the...
-
CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...
-
Discuss which organizational structure (i.e. functional, product-market divisional, matrix) you would recommend Guelph General Hospital implement, assuming the hospital moves forward with the...
-
Use a calculator to obtain solutions correct to the nearest hundredth in Problems 4954. 0.02x +0.831x + 0.0069 = 0
-
Use MATLAB to carry out the following multiplication of polynomials: x(x - 1.7)(x + 0.5)(x - 0.7)(x + 1.5) Plot the polynomial for -1.6 < x < 1.8.
-
The length of a rod was measured eight times. The measurements in centimeters, in the order they were taken, were 21.20, 21.22, 21.25, 21.26, 21.28, 21.30, 21.32, 21.35. a. Do these measurements...
-
Performance evaluation seeks to achieve goal congruence and managerial effort. Describe what is meant by this statement.
-
Two identical spheres with mass m are hung from silk threads of length L, as shown in Fig. 21.44. Each sphere has the same charge, so q1 = q2 = q. The radius of each sphere is very small compared to...
-
1 point A meteorologist measures the angle of elevation to her weather balloon as 33 degrees. A radio signal from the balloon indicates that it is 1601 meters diagonally from her location. How high...
-
Lakukan ANALISIS VARIAN (ONE WAY ANOVA) dan UJI HIPOTESIS pada taraf nyata 0,05 bahwa rataan lamanya jam kesembuhan yang diakibatkan oleh ketiga merk obat sama saja atau ada perbedaan
-
Evaluate the integral. 9,2 r+8 dr
-
(c) Data Table 2 shows data taken in a free-fall experiment. Measurements were made of the distance of fall (19 at each of four precisely measured times. Complete the table. Use only the proper...
-
Seven Sages, LLC made $400,000 is sales during the month of July, of which 30% constituted cash sales. The remaining amount were sales made on credit. In August, sales on account totaled $300,000,...
-
Discuss your organizationscorporate, business and functional strategies. How does each general level of strategy relate to human resource management? If you are currently unemployed, you can research...
-
Respond to the following questions: What are the qualifications for licensure in your state? What is the scope of practice for your state? In other words, what are nurses allowed to do/expected to do...
-
Review Discussion Rubric Individual Discussion Board Rubric Module #4 and post your responses in the Individual Decision Making Key Concepts Discussion board. Describe a decision you have made that...
-
Explain why it is not wise to accept a null hypothesis.
-
The accounting rate of return on the initial investment presented in question 4 is: a. 0.125 b. 0.156 C. 0.219 d. 0.375
-
For a typical \($120,000\) investment in equipment with a 5-year life and no salvage value, determine the present value of the tax shield using straight-line depreciation. Assume an income tax rate...
-
Each of the following statements is true regarding capital budgeting decisions, except: a. Capital expenditure proposals involve risk. b. Acommon error is to invest in unnecessary or overly complex...
Study smarter with the SolutionInn App