Ben Dover (Eileens brother) is purchasing a duplex in Colorado Springs for $650,000 and is financing the purchase with a mortgage loan Here are the particulars 80 LTV Loan 1 3 625 interest rate w no points Loan 2 3 250 interest rate w 1 5 points 15 year term Monthly payments Required Prepare amortization schedules for each of the two loan alternatives Set these up to show year end balances, not month end balances Calculate the effective interest rates for each, assuming no early repayment Calculate the effective interest rates for each, assuming the loans are paid off at the end of year four (4) Calculate the breakeven point for recovery of points for the second loan Calculate the IRR for the second loan, assuming (a) the loan is carried to full term and (b) the loan is repaid at the end of year 4

Question: Ben Dover (Eileens brother) is purchasing a duplex in Colorado Springs for $650,000 and is financing the purchase with a mortgage loan. Here are the

Ben Dover (Eileen’s brother) is purchasing a duplex in Colorado Springs for $650,000 and is financing the purchase with a mortgage loan. Here are the particulars:

80% LTV

Loan 1: 3.625% interest rate w no points

Loan 2: 3.250% interest rate w 1.5 points

15-year term

Monthly payments

Required:

Prepare amortization schedules for each of the two loan alternatives. Set these up to show year-end balances, not month-end balances.
Calculate the effective interest rates for each, assuming no early repayment.
Calculate the effective interest rates for each, assuming the loans are paid off at the end of year four (4).
Calculate the breakeven point for recovery of points for the second loan.
Calculate the IRR for the second loan, assuming (a) the loan is carried to full term and (b) the loan is repaid at the end of year 4.

Step by Step Solution

★★★★★

3.57 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Loan 1 Year 1 5208 Year 2 5208 Year 3 5208 Year 4 5208 Year 5 5208 Loan 2 Yea... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

7) TCL is also considering an electronic manufacturing system. The treasurer has collected the following information about the proposed system. a. This project will last only 3 quarters. b. The...

A $92 000 mortgage with a 25-year term is repaid by making payments at the end of each month. If interest is 5.8% compounded semi- annually, how much are the payments?

Contractual Allowances Physician Office Revenue for Visit Code 99214 has a full established rate of $72.00. Of ten different payers, there are nine different contracted rates, as follows: Contracted...

Calculate the effective interest rate on loans with the following minimum compensating balancerequirements: Loan Rate Compensating Balance b. C. d. 6.5% 12.0% 10.5% 14.0% 8.5% 20% 10% 15% 25% 30%

At the end of last year, June, a 30% partner in the four-person BJJM Partnership, had an outside basis of $75,000 in the partnership, including a $60,000 share of partnership debt. Junes share of the...

Using the status chart in Figure 11-20: a. Estimate AV, SV, CV, and TV, and compute SPI and CPI for Week 30. Interpret the results. b. Compute ETC and EAC. Estimate the revised completion date and...

Ben Dover (Eileens brother) is purchasing a duplex in Colorado Springs for $650,000 and is financing the purchase with a mortgage loan. Here are the particulars: 80% LTV Loan 1: 3.625% interest rate...

. Ben Dover (Eileens brother) is purchasing a duplex in Colorado Springs for $650,000 and is financing the purchase with a mortgage loan. Here are the particulars: 80% LTV Loan 1: 3.625% interest...

For each of the following situations, indicate whether assets, liabilities, equity, revenues, and expenses are overstated (too high), understated (too low), or unaffected by the error in the December...

Which of the following contains a 77 bond? Check all that apply. HO 03 HCN CO3- Which of the following contains a delocalized T bond? Check all that apply. oooo HO 03 HCN CO3-

List five ratios that are automatically provided by the vertical analysis of income statements.

If the midpoint of two points is ( 3 , - 4 ) , and one of the endpoints is ( - 7 , 0 ) , find the other endpoint.

Treasure Land Corporation incurred the following costs in 2010. Prepare the necessary 2010 journal entry or entries for TreasureLand. Cost of laboratory research almed at discovery of new knowledge...

Capriati Corporation commenced operations in early 2012. The corporation incurred $60,000 of costs such as fees to underwriters, legal fees, state fees, and promotional expenditures during its...

On September 1, 2012, Winans Corporation acquired Aumont Enterprises for a cash payment of $700,000. At the time of purchase, Aumonts balance sheet showed assets of $620,000, liabilities of $200,000,...

Big Sky Mining Company must install $1.5 million of new machinery in its Nevada mine. It can obtain a bank loan for 100 percent of the purchase price, or it can lease the machinery. Assume that the...

Two companies, Energen and Hastings Corporation, began operations with identical balance sheets. A year later, both required additional manufacturing capacity at a cost of $50,000. Energen obtained a...

I do believe that initiatives like the Federal Select Agent Program have a crucial impact. These programs assist in ensuring that laboratories take the appropriate safety measures when handling...

QUESTION 1 Julian Knight is currently 58 years of age, and has met a condition of release (with superannuation only). He has $80,000 in tax-free super, and $490,000 taxed super sitting in his fund....

Hey guys, I need help mostly with the part on "More on the PoliceData class" regarding the IssueInfractions part The Driver, Vehicle & Infraction Classes Define a class called Driver that defines the...

I have four questions. Please answer. QUESTION 1 Julian Knight is currently 58 years of age, and has met a condition of release (with superannuation only). He has $80,000 in tax-free super, and...

Olympus Property Management owns two million square feet of land (about 46 acres) in the Woodlands. The managers have two projects for developing this property: Galleria West Shopping Plaza, NPV =...

thanks. will thumbs up. Olympus Property Management owns two million square feet of land (about 46 acres) in the Woodlands. The managers have two projects for developing this property: Galleria West...

Can anyone answer this assignment and please write down why you have those answers? Thank you so much. Tax II Fall 2017 Tax Assignment Well, it's been a busy day in your office. Here it is April 23,...