Reference no: EM1364617
You have contracted to purchase a $10,000,000 multi-family property with $2,000,000 cash down payment as equity and an $8,000,000 mortgage loan. Assume mortgage rates for this type of investment property are 8.50% fixed rate, fully amortized over 30 years, with monthly payments of interest and principal.
(1) Construct an amortization schedule showing interest and principal payments for each month of the thirty year term. Also show the outstanding loan balance (unpaid principal balance) at the end of each month. Graph the balance outstanding over time. If your holding period is only five years, how much will you still owe after 60 months? You may assume no unscheduled payments of principal occur prior to that time.
(2) Suppose another lender offers 8.00% interest, fixed rate, also amortized over 30 years with monthly payments of interest and principal, but with loan maturity in 10 years, i.e. after 120 payments. Develop a similar amortization schedule for this alternative loan structure then answer the following questions.
What would be the difference in monthly payments between the two options?
What would be the amount of the balloon payment in 10 years?
Under which loan option would you pay the more total dollars of interest? More total dollars of principal?
|
Assuming she starts from rest and accelerates
: A baseball player runs 27.4meters from the batter's box to first base,overruns first base by 3.0 meters,and then returns to first base. Compared to total distance traveled by the player,the magnitude of the players total displacement from the batt..
|
|
Make report to print gross earnings and tax payable
: Your report is to print the gross earnings, tax payable, medical levy and net earnings for each employee. At the end of the report, print the total gross earnings, total tax, total medical levy and total net earnings.
|
|
Interest in sport psychology
: What is a mood state and why is it of interest in sport psychology? How are mood states measured? In this solution, the Profile of Mood States (POMS) questionnaire is described.
|
|
How did petters conduct a billion ponzi scheme
: Discuss how Petters Group Worldwide / Petters Company Inc. were able to conduct a $3.65 billion Ponzi scheme. Using the concepts and framework of Enterprise Risk Management, COSO,
|
|
Construct an amortization schedule showing interest
: You have contracted to buy a $10,000,000 multi-family property with $2,000,000 cash down payment as equity and an $8,000,000 mortgage loan.
|
|
Explain improves the interview process
: Explain improves the interview process for the Human Resources Department of your organization
|
|
Write sql statement to produce single column
: Write an SQL statement to produce a single column called ItemLocation that combines the SKU_Description,the phrase "is located in."
|
|
What is the spring constant for the chair
: A 425 kg bear grasping a vertical tree slides down at constant velocity. What is friction force that acts on the bear.
|
|
Show open systems theory question
: What is Open systems Theory and How can open systems Theory be used to understand an organization
|