Real Estate Finance And Investments
Real Estate Finance And Investments
6th Edition
ISBN: 9781259919688
Author: BRUEGGEMAN, William B., Fisher, Jeffrey D.
Publisher: Mcgraw-hill Education,
Question
Book Icon
Chapter 4, Problem 2P

a.

Summary Introduction

To calculate: Monthly payments.

a.

Expert Solution
Check Mark

Explanation of Solution

Formula to calculate monthly payment is as follows:

Monthly payment=Principal×(MLC at 6% for 25 years)

Monthly payment=$80,000×0.006443=$515.44

b.

Summary Introduction

To calculate: Interest and principle payments during month 1.

b.

Expert Solution
Check Mark

Explanation of Solution

Formula to calculate interest is as follows:

Interest=Principle×Interest rate12

Substitute equation with $80,000 for principle, 6% for interest rate to calculate interest.

Interest=$80,000×6%12=$400

Calculation of monthly payment during month 1 is as follows:

Monthly payment=Monthly paymentInterest

Substituting equation with 515.44 for monthly payment and $400 for interest to calculate payment during month 1.

Monthly payment=$515.44$400=$115.44

c.

Summary Introduction

To calculate: Total principle and total interest paid over 25 years.

c.

Expert Solution
Check Mark

Explanation of Solution

Formula to calculate total payment is as follows:

Total payment=Monthly payment×25×24

Substituting equation with $515.44 for monthly payment to calculate total payments.

Total payment=$515.44×25×24=$154,632

Total payment is $154,632.

Formula to calculate total interest payment is as follows:

Total interest payment=Total paymentsprinciple payment

Substituting equation with $154,632 for total payments and $80,000 for principle payments to calculate total interest payment.

Total interest payment=$154,632$80,000=$74,632

d.

Summary Introduction

To determine: Outstanding loan balance if the loan is repaid at the end of year 10.

d.

Expert Solution
Check Mark

Explanation of Solution

Formula to calculate future value is as follows:

Future value=Present value(1+i)n

Substituting equation with $80,000 for present value, 0.50 for I and 120 for n to calculate future value.

Future value=$80,000(1+0.50)120=$61,081

e.

Summary Introduction

To calculate: Total monthly interest and principle payments through 10 years.

e.

Expert Solution
Check Mark

Explanation of Solution

Formula to calculate total interest payment is as follows:

Total payments=Monthly payment×n

Substituting equation with $515.44 for monthly interest and 120 for n to calculate total payment.

Total payments=$515.44×120=$61,852.80

Formula to calculate total principle payment is as follows:

Total principle payments=Loan amountPresent value of the loan at the end of 10 years

Substituting equation with $80,000 for loan amount and $61,081.77 for present value to calculate total principle payment.

Total principle payments=$80,000$61,081.77=$18,918.23

Formula to calculate total interest payment is as follows:

Total interest payments=Total paymentstotal principle payment

Substituting equation with $61,852 for total payments and $18,918.23 for total principle payment to calculate total interest payment.

Total interest payments=$61,852.80$18,918.23=$42,934.57

f.

Summary Introduction

To calculate: Breakdown of interest and principle during month 50.

f.

Expert Solution
Check Mark

Explanation of Solution

Present value of the outstanding loan at the end of month 49 is $73,608.28, formula to calculate interest payment is as follows:

Total interest payments=outstanding loan balance×interest rate

Substituting equation with $73,608.28 for outstanding loan and 0.50% for the interest rate.

Total interest payments=$73,608.28×0.50%=$368.04

Formula to calculate principle payment is as follows:

Principle payment=Total paymentInterest payment

Substituting equation with $515.44 for total payment and $368.04 for interest payment to calculate principle payment.

Principle payment=$515.44$368.04=$147.40

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Crenshaw, Incorporated, is considering the purchase of a $367,000 computer with an economic life of five years. The computer will be fully depreciated over five years using the straight-line method. The market value of the computer will be $67,000 in five years. The computer will replace five office employees whose combined annual salaries are $112,000. The machine will also immediately lower the firm's required net working capital by $87,000. This amount of net working capital will need to be replaced once the machine is sold. The corporate tax rate is 22 percent. The appropriate discount rate is 15 percent. Calculate the NPV of this project. Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. NPV Answer is complete but not entirely correct. S 103,141.80
Your firm is contemplating the purchase of a new $610,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $66,000 at the end of that time. You will save $240,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $81,000 (this is a one-time reduction). If the tax rate is 21 percent, what is the IRR for this project? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. IRR %
QUESTION 1 Examine the information provided below and answer the following question. (10 MARKS) The hockey stick model of start-up financing, illustrated by the diagram below, has received a lot of attention in the entrepreneurial finance literature (Cumming & Johan, 2013; Kaplan & Strömberg, 2014; Gompers & Lerner, 2020). The model is often used to describe the typical funding and growth trajectory of many startups. The model emphasizes three main stages, each of which reflects a different phase of growth, risk, and funding expectations. Entrepreneur, 3 F's Debt(banks & microfinance) Research Business angels/Angel Venture funds/Venture capitalists Merger, Acquisition Grants investors PO Public market Growth (revenue) Break even point Pide 1st round Expansion 2nd round 3rd round Research commercial idea Pre-seed Initial concept Seed Early Expansion Financial stage Late IPO Inception and prototype Figure 1. The hockey stick model of start-up financing (Lasrado & Lugmayr, 2013) REQUIRED:…
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Text book image
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:9781260013962
Author:BREALEY
Publisher:RENT MCG
Text book image
Financial Management: Theory & Practice
Finance
ISBN:9781337909730
Author:Brigham
Publisher:Cengage
Text book image
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education