Suppose you take out a $101,000, 20-year mortgage loan to buy a condo. The interest rate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose you take out a $101,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 4%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. Req A Year 1 N35600 2 9 10 11 12 Construct a mortgage amortization. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required. Enter all values as positive value. 34567892 13 14 15 16 17 18 19 Req B 20 Beginning-of-Year Balance Req C and D 101,000.00 Req E to G Year-End Interest Due on Balance Year-End Payment Req H < Req A Req 11 Amortization of Loan Req 12 and J End-of-Year Balance Req C and D > Req A Req B c. Initial interest d. Amortization Req C and D Req E to G % % c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? Note: Do not round intermediate calculations. Enter your answers as a whole percent. Req H < Req B Req 11 Req E to G > Req 12 and J Complete this question by entering your answers in the tabs below. Req C and D Req E to G e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 1%, what is the real value of the first (year-end) payment? g. If the inflation rate is 1%, what is the real value of the last (year-end) payment? Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Req A Req B e. Paid off loan f. Real value of the first payment g. Real value of the last payment Req C and D Req H Req 11 Req H > Req 12 and J Complete this question by entering your answers in the tabs below. Req A Req C and D Req E to G Req H Now assume the inflation rate is 7% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? Note: Do not round intermediate calculations. Enter your answer as a whole percent. New nominal interest rate % Req B < Req E to G Req 11 Req 11 > Req 12 and J Complete this question by entering your answers in the tabs below. Req A Req B Req C and D Req E to G i-2. Real value of the first payment j. Real value of the first payment Req H < Req 11 Req 11 i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last payment in this high-inflation scenario? Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Req 12 and J Req 12 and J Suppose you take out a $101,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 4%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. Req A Year 1 N35600 2 9 10 11 12 Construct a mortgage amortization. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required. Enter all values as positive value. 34567892 13 14 15 16 17 18 19 Req B 20 Beginning-of-Year Balance Req C and D 101,000.00 Req E to G Year-End Interest Due on Balance Year-End Payment Req H < Req A Req 11 Amortization of Loan Req 12 and J End-of-Year Balance Req C and D > Req A Req B c. Initial interest d. Amortization Req C and D Req E to G % % c. What fraction of your initial loan payment is interest? d. What fraction of your initial loan payment is amortization? Note: Do not round intermediate calculations. Enter your answers as a whole percent. Req H < Req B Req 11 Req E to G > Req 12 and J Complete this question by entering your answers in the tabs below. Req C and D Req E to G e. What is the total of the loan amount paid off after 10 years (halfway through the life of the loan)? f. If the inflation rate is 1%, what is the real value of the first (year-end) payment? g. If the inflation rate is 1%, what is the real value of the last (year-end) payment? Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Req A Req B e. Paid off loan f. Real value of the first payment g. Real value of the last payment Req C and D Req H Req 11 Req H > Req 12 and J Complete this question by entering your answers in the tabs below. Req A Req C and D Req E to G Req H Now assume the inflation rate is 7% and the real interest rate on the loan is unchanged. What must be the new nominal interest rate? Note: Do not round intermediate calculations. Enter your answer as a whole percent. New nominal interest rate % Req B < Req E to G Req 11 Req 11 > Req 12 and J Complete this question by entering your answers in the tabs below. Req A Req B Req C and D Req E to G i-2. Real value of the first payment j. Real value of the first payment Req H < Req 11 Req 11 i-2. What is the real value of the first (year-end) payment in this high-inflation scenario? j. What is the real value of the last payment in this high-inflation scenario? Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Req 12 and J Req 12 and J
Expert Answer:
Answer rating: 100% (QA)
It looks like the question is about constructing a mortgage amortization table for a 101000 20year mortgage with an annual interest rate of 4 Youre as... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-0077861629
8th edition
Authors: Richard Brealey, Stewart Myers, Alan Marcus
Posted Date:
Students also viewed these finance questions
-
find intervals of convergence of f(x), f'(x), f''(x) and the antiderivative of f(x). check for endpoints . f(x) = = n=1 (1)"+(x 2)" n
-
Please do the full calculation through the financial calculator formula as per the Australian standards Question 1 (Total marks for this question = 6 marks) Suppose you take out a loan of $10,000,...
-
Suppose you take out a $100,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 6%, and to keep things simple, we will assume you make payments on the loan annually at the end...
-
1-Kristen prefaces her speech by talking about her inability to save or invest money. For that reason, she does her speech on an online money management course and focuses on the skills she learned...
-
Transfer pricing and fixed cost per unit The Graca Division of Pryor Company currently produces electric fans that desktop computer manufacturers use as cooling components. The Hackney Division,...
-
Some other information related to the year ended 30 June 2016: a. Credit sales, $130 000. b. Purchase of inventory on credit, $70 000. c. No dividends were declared or paid. Required: 1. What was...
-
Tom Bonacci brought his Jeep to Brewer Service Station to investigate a strange noise the vehicle was making. The Jeep was raised up on an automobile lift so that Brewer employee Paul Gebing could...
-
Spencer Enterprises is attempting to choose among a series of new investment alternatives. The potential investment alternatives, the net present value of the future stream of returns, the capital...
-
5. Consider uniform, inviscid, supersonic flow exhausting from a rocket engine nozzle. For fixed back pressure p (i.e., the ambient pressure outside the nozzle), qualitatively draw the first few wave...
-
Process costing becomes more complicated when there are both beginning and ending work in process (BWIP and EWIP) inventories. The costs stored in BWIP were incurred during the prior period. A...
-
An regenerative engine receives 68,000 kg/hr of steam having 1 open heater which receives 15,400 kg/h of Bled steam. If the condenser pressure is 0.008 MPa and the open heater pressure is 0.98 MPa...
-
A survey about color preferences reported the age distribution of the people who responded. Here are the results: Age group (years) 1-18 19-24 25-35 36-50 51-69 70 and over Count 11 97 75 36 16 5 (a)...
-
Logically, and being completely financially astute about it, we should pay down the balances that carry the highest interest rates, first, when there is money due on multiple credit cards. However,...
-
In this animated text presentation, the concepts of personal budgeting are outlined. While this is sponsored by a particular financial group, it offers some practical information about this topic....
-
On January 1 , 2 0 1 2 , Harrison's, Inc., borrowed $ 9 0 , 0 0 0 at 1 2 % payable annually to finance the construction of a new building. The building was completed December 3 1 , 2 0 1 2 . In 2 0 1...
-
1. Show two effects that have actually been experienced by Singapore, due to the collapse of US banks this year. Evidence should be given to prove the presence of each effect. 2. Analyse one factor...
-
I roll 12 fair and 6 sided dices. I obtain a sum. How do I calculate the probability of the sum being greater than 42? The same with 50.
-
3.16. For a system with non-identical service rates (see Sect. 3.5) and a limit of N jobs in the system (Eq. 3.13), obtain an expression for the mean service time per job, E[Ts], as a function of the...
-
A firm currently has a debt-equity ratio of 1/2. The debt, which is virtually riskless, pays an interest rate of 6%. The expected rate of return on the equity is 12%. What would happen to the...
-
a. A corporation cannot pay a dividend if its legal capital is impaired or if it is insolvent. b. The effective tax rate on capital gains can be less than the stated rate. c. Managers and investors...
-
Here are simplified financial statements for Phone Corporation in a recent year: Calculate the following financial ratios for Phone Corporation: a. Return on equity b. Return on assets c. Return on...
-
Consider an open economy characterized by the following equations: The parameters \(m_{1}\) and \(x_{1}\) are the propensities to import and export. Assume that the real exchange rate is fixed at a...
-
Consider an open economy in which the real exchange rate is fixed and equal to one. Consumption, investment, government spending, and taxes are given by where \(Y^{*}\) denotes foreign output. a....
-
Label each of the following statements true, false, or uncertain. Explain briefly. a. The interest rate parity condition means that interest rates are equal across countries. b. Other things being...
Study smarter with the SolutionInn App