You want to purchase a condo in downtown Boston for $1,200,000. You can finance 80% of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You want to purchase a condo in downtown Boston for $1,200,000. You can finance 80% of its cost by receiving a 20-year mortgage. Considering your income and your credit score, your bank offered 4.5% interest on your mortgage. For simplicity assume that you make yearly payments to your mortgage. Build an amortization schedule for this loan in Excel and answer the following questions. a. How much in total do you have to pay back to the bank? b. How much do you owe to the bank at the end of year 10? c. At the end of year 10, you decide to refinance your home with a new 15-year 3.5% mortgage. How much is your new yearly payment? d. Consider the initial mortgage (not the case where you refinanced). Starting from year 11, you decide to increase your yearly payments by 10% hoping that it helps you pay off your mortgage sooner. In this case, how long does it take for you to pay off your mortgage? Complete the following table. Period Semi-Annual Quarterly Monthly Daily APR 8% 9% 7.5% 4.25% Compounding Periodic Per Year Rate Effective Annual Rate You need $10'000 for 2 years and you go to your bank asking for a loan. The loan officer gives you the following options: a) 12% APR, yearly compounding b) 11.5% APR, semi-annually compounding c) 11 % APR, monthly compounding Which one would you choose and why? You want to purchase a condo in downtown Boston for $1,200,000. You can finance 80% of its cost by receiving a 20-year mortgage. Considering your income and your credit score, your bank offered 4.5% interest on your mortgage. For simplicity assume that you make yearly payments to your mortgage. Build an amortization schedule for this loan in Excel and answer the following questions. a. How much in total do you have to pay back to the bank? b. How much do you owe to the bank at the end of year 10? c. At the end of year 10, you decide to refinance your home with a new 15-year 3.5% mortgage. How much is your new yearly payment? d. Consider the initial mortgage (not the case where you refinanced). Starting from year 11, you decide to increase your yearly payments by 10% hoping that it helps you pay off your mortgage sooner. In this case, how long does it take for you to pay off your mortgage? Complete the following table. Period Semi-Annual Quarterly Monthly Daily APR 8% 9% 7.5% 4.25% Compounding Periodic Per Year Rate Effective Annual Rate You need $10'000 for 2 years and you go to your bank asking for a loan. The loan officer gives you the following options: a) 12% APR, yearly compounding b) 11.5% APR, semi-annually compounding c) 11 % APR, monthly compounding Which one would you choose and why?
Expert Answer:
Answer rating: 100% (QA)
Here are the stepbystep calculations for each question a Total amount paid back to the bank Original ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
A company estimates that the marginal cost (in dollar per item) of producing x items is 1.73 - 0.004x. if the cost of producing one item is $566, find the cost of producing 100 items. (Round your...
-
An equation of motion is given, where is in meters and t in seconds. Find (a) The times at which the acceleration is 0 and (b) The displacement and velocity at these times. 47. s =r-4 - 912 48. s =...
-
In an experiment that is designed to measure the Earths magnetic field using the Hall effect a copper bar 0.500 cm thick is positioned along an eastwest direction. If a current of 8.00 A in the...
-
This problem can be solved analytically or with a spreadsheet. Two identical large glass bulbs are filled with gases and connected by a capillary tube that is \(\delta=0.0090\) \(\mathrm{m}\) long....
-
Introduction Home Safety, Inc.s management has been trying for months to acquire one of its largest competitors in the home security industryLock-It-Up Company. Before agreeing to the acquisition,...
-
1.In the Hofstede framework the term "power distance" refers to what?
-
Mary and Charles have owned a beach cottage on the New Jersey shore for several years and have always used it as a family retreat. When they acquired the property, they had no intentions of renting...
-
1. The misstatements below are included in the accounting records of the Dilon Manufacturing Company Read the requirements'. Requirement a. Identify whether each misstatement is an error or fraud....
-
How do you characterize random variations in system inputs sufficiently to bound the range of acceptable values in terms of Normal Distribution with standard deviations?
-
Define frequency response of a system.
-
State and explain open-loop and closed-loop transfer function.
-
In what situation is the assessed level of control risk most likely to be maximum?
-
Define open-loop control and closed-loop control.
-
Is the term (x+2) a factor of the polynomial shown below? f(x)=x-10x+27x-12
-
Identify the tax issues or problems suggested by the following situations. State each issue as a question. Jennifer did not file a tax return for 2007 because she honestly believed that no tax was...
-
Define and describe the Lifelong Learning Plan (LLP)?
-
What are mutual funds? What are some of the features of a mutual fund?
-
Santos and Cecilia (from problem 10) have the following liabilities: Fair Market Value Mortgage ................................$81000 Car loan ....................................2750 Credit card...
-
On January 1, 2011, Oswalt Company had a balance of \(\$ 156,000\) in its Land account. During 2011, Oswalt sold land that had cost \(\$ 66,000\) for \(\$ 98,000\) cash. The balance in the Land...
-
Security Services, Inc. (SSI), recognized \(\$ 2,400\) of sales revenue on account and collected \(\$ 1,900\) of cash from accounts receivable. Further, SSI recognized S900 of operating expenses on...
-
On January 1, 2011, MMC Company had a balance of \(\$ 700,000\) in its Bonds Payable account. During 2011, MMC issued bonds with a \(\$ 200,000\) face value. There was no premium or discount...
Study smarter with the SolutionInn App