Question

Your friend is considering buying a property for Sh, 50,000. If purchased the property will be...

Your friend is considering buying a property for Sh, 50,000. If purchased the property will be financed 60% by debt at 15% p.a. payable monthly for 5 years. The property will generate NOI of Sh, 5,000 and Sh, 8,000 in year 1 and 2 respectively. The property can be sold for Sh, 60,000 at the end of year 2. The required rate of return is 25%. Calculate the BTIRR and advise. (Show your workings to a reasonable extent)

Homework Answers

Answer #1

Based on the given data, pls find below:

YEAR 0 1 2 Terminal
Property - Cash Flows      -50,000           5,000           8,000         60,000
IRR 14.87%

Using IRR (Series of Cash Flows) in Excel, the IRR is calculated above and is 14.87%;

Since IRR is much lower than the Required Rate of Return of 25%, this is not feasible to invest.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Suppose your friend Paul is considering buying a new Honda Accord. He is going to make...
Suppose your friend Paul is considering buying a new Honda Accord. He is going to make monthly payments (at the end of each month) of $557.08 on a loan of $28,000. If the annual percentage rate is 7.20%, how long in years is the loan for? Please show work using financial formula. NOT EXCEL FORMULA And please show inputs for the financial calculator. -Thanks
Murphy Construction is considering buying a new crane. It will cost $200,000. They will pay $50,000...
Murphy Construction is considering buying a new crane. It will cost $200,000. They will pay $50,000 to have it modified and delivered. It has a five-year class life. At the end of three years, they plan to sell the machine for $100,000. The new machine will allow MC to increase revenues by $90,000 each year and expenses will increase by $10,000 each year. Inventory will increase by $3,000 if the machine is purchased, accounts payable will decrease by $1,000 and...
8)Your friend JJ purchased a property for development. The property had a cost basis of $5,000,000,...
8)Your friend JJ purchased a property for development. The property had a cost basis of $5,000,000, JJ paid $1,250,000 cash, the remaining $3,750,000 financed via non-recourse mortgage. Unfortunately, the development was a flop and JJ couldn’t meet the mortgage payment. At the time of default, the mortgage had a balance of $6,500,000 due to refinancing. The accumulated depreciation was $650,000 fair market value at the time of foreclosure was $6,000,000. What is the gain or loss on foreclosure? A. Gain...
BHP is considering buying in a new iron ore mine which is forecasted to start earning...
BHP is considering buying in a new iron ore mine which is forecasted to start earning $5,000,000 of revenue in the second year of operation. Revenue is projected to increase at 10% p.a., operating costs are 25% of annual revenue and the mine is kept for 3 years of revenue, after which it is expected to be sold for $5mil. Setting up the mine requires $2mil today and $4mil in the first year. 60% of BHPs capital is financed through...
Your company is considering the acquisition of a machine with an initial investment of $50,000, that...
Your company is considering the acquisition of a machine with an initial investment of $50,000, that will generate the following after-tax cash flows: year 1 $25,000 year 2 $24,000 year 3 $23,000 If the company tax rate is 20% and the cost of capital is 10%, What is the discounted payback period?
Your firm is considering buying an old office building with a remaining service life of 25...
Your firm is considering buying an old office building with a remaining service life of 25 years. Tenants have recently signed long term leases providing rental income of $250,000 / year for the next 5 years, increasing by 10% in 5 year increments. You estimate operating expenses, including taxes, will be $85,000 the first year, increasing by $5,000 each subsequent year. The salvage value after 25 years you estimate will be $50,000. If your next best alternative offers an ROI...
Your company is considering the acquisition of a machine with an initial investment of $50,000, that...
Your company is considering the acquisition of a machine with an initial investment of $50,000, that will generate the following after-tax cash flows: year 1 $25,000 year 2 $24,000 year 3 $23,000 If the company tax rate is 20% and the cost of capital is 10%, What is the discounted payback period? Seleccione una: 2.59 years 2.04 years 2.36 years 2.47 years 2.95 years 2.65 years
Question 2 A property is expected to generate $300,000 of NOI over the next 12 months....
Question 2 A property is expected to generate $300,000 of NOI over the next 12 months. Discussion with lenders leads to the conclusion that the minimum acceptable debt-coverage ratio will be 1.20 and that loan terms will be 8% per annum, with 20-year amortization (monthly payments). A. What is the maximum supportable annual debt service? Solve 3 ways: - the PV or PMT functions on Google Sheets - your HP 12c (tell me which keys you used) -the Mortgage Constant...
Bobcat Coffee had sales of goods totaling $200,000, receiving $150,000 in cash and $50,000 on account....
Bobcat Coffee had sales of goods totaling $200,000, receiving $150,000 in cash and $50,000 on account. The cost of the goods sold were $60,000. Bobcat Coffee purchased $80,000 of inventory. All purchases were on account. Bobcat Coffee paid salaries of $50,000. This was payment for salaries of $35,000 and $15,000 that was payable from last year. Bobcat Coffee purchased $7,000 of supplies. All of these purchases were on account. Bobcat Coffee received $40,000 cash from customers who had been granted...
A company is considering buying a new machine and replacing the old one. The managers have...
A company is considering buying a new machine and replacing the old one. The managers have collected the following information: Current machine (old machine): ISK ISK The purchase price 50,000 Accumulated depreciation 40,000 Annual operating expenses 5,000 market 1,500 Impact value after 5 years 0 Repair of current machine (old machine): Repair costs, improvements 12,000 Annual operating expenses after improvements 2,000 New engine: The purchase price 56,000 Annual operating expenses 1,000 Impact value after 5 years 0 1. What is...