Question

Take a look at Q9, and determine the IRR of this. You can use excel, but...

Take a look at Q9, and determine the IRR of this. You can use excel, but show both your yearly values and the indicate which cells the IRR function is used on for full marks.

Q9 You’re considering purchasing a franchise for an old hardware store and operating it for 5 years. In order to purchase the store, you need to pay $93,782.8 for the property as well as $15,733.5 of back taxes (they were due a year ago, and were not paid by the previous owner). To run the store for 5 years, will cost you $51340 per year, and there will be a yearly tax that you need to pay of $5240. In exchange, you will get a yearly income from the store of 83,512.2. At the end of 5 years, you can expect to be able to sell the store for $205,232.5 . What is the annual worth of owning this business (assuming you buy and sell it over the 5 year period if your cost of capital is 5%?

Type the answer to this in the box below and upload your work and cash flow diagram as part of your assignment submission.

ANS: (38,781.02)

Homework Answers

Answer #1

Calculation of IRR

Year Cash Flows
0 $ (109,516.30)
1 $       26,932.20
2 $       26,932.20
3 $       26,932.20
4 $       26,932.20
5 $     232,164.70
IRR 34%

For any clarification, please comment. Kindly Up Vote

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
NPV AND IRR A store has 5 years remaining on its lease in a mall. Rent...
NPV AND IRR A store has 5 years remaining on its lease in a mall. Rent is $2,000 per month, 60 payments remain, and the next payment is due in 1 month. The mall's owner plans to sell the property in a year and wants rent at that time to be high so that the property will appear more valuable. Therefore, the store has been offered a "great deal" (owner's words) on a new 5-year lease. The new lease calls...
Using the Payback Method, IRR, and NPV Problems Purpose of Assignment The purpose of this assignment...
Using the Payback Method, IRR, and NPV Problems Purpose of Assignment The purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods. Assignment Steps Resources: Corporate Finance Calculate the following time value of money problems in Microsoft Excel or Word document. You must show all of your calculations. If you want to accumulate $500,000 in 20 years, how much do you...
Please use Excel to answer the following TVM questions. You can use this spreadsheet to set...
Please use Excel to answer the following TVM questions. You can use this spreadsheet to set up your calculations if you so desire. Unless indicated otherwise, assume that all of the problems are ordinary annuities (payment made at the end of the period).        Part 5 A company is going to issue debt in the form of bonds. The bonds will pay $50 every 6 months to the bond investor. The bonds have a 10 year term and when the bonds...
You have the opportunity to get a VEGGIE Café franchise (this specializes in BOCA veggie Burgers...
You have the opportunity to get a VEGGIE Café franchise (this specializes in BOCA veggie Burgers and other heart-healthy fast foods). You now manage three Big Bird Stick-e-Chicken shops for another owner, and feel you are ready to be your own boss. You estimate your VEGGIE will gross $250,000 in annual sales. You will have to pay Veggie, Inc., an annual franchise fee of $5,000 plus another 3% of your gross sales. Advertising expenses have two parts: local advertising (which...
PLEASE SHOW WORK IN EXCEL* A bank owned “fixer-upper” property is selling for $500,000. You are...
PLEASE SHOW WORK IN EXCEL* A bank owned “fixer-upper” property is selling for $500,000. You are considering purchasing the property from the bank, and have run the following estimates: Lawyer and broker fees to purchase: $22,000 Monthly repair and maintenance for the first year: $5000 Monthly repair and maintenance after the first year: $700 The bank wants to get rid of the property soon, so they are offering a seller financed 90% LTV interest only loan at a 5.5% rate,...
Please show the formula from excel if you can. Thanks Question 1 : A company has...
Please show the formula from excel if you can. Thanks Question 1 : A company has the opportunity to expand its business operations by acquiring new plant and equipment. The plant and equipment will cost $80,000 and have a useful life of 6 years. At the end of the period the plant and equipment will have a salvage value of $10,000. The Tax Office allows the company to depreciate this equipment at 25% per annum using the prime cost method...
A firm is considering Projects S and L, whose cash flows are shown below. These projects...
A firm is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. The CEO wants to use the IRR criterion, while the CFO favors the NPV method. You were hired to advise the firm on the best procedure. If the wrong decision criterion is used, how much potential value would the firm lose? WACC: 6.75% 0 1 2 3 4 CFS -$1,025 $380 $380 $380 $380 CFL -$2,150...
1) You want to start an organic garlic farm. The farm costs $190,000, to be paid...
1) You want to start an organic garlic farm. The farm costs $190,000, to be paid in full immediately. Year 1 cash inflow will be $25,000, after which the inflows are expected to grow at a 5% annual rate until the end of year 5 when you anticipate selling the farm for $300,000 (at the end of year 5 you get both the cash inflow from operations and from selling the farm). What is the IRR of your garlic farm...
Solve using a financial calculator: please show each step you use on the financial calculator! 1....
Solve using a financial calculator: please show each step you use on the financial calculator! 1. Given the following information, calculate the NPV for this property. Initial cash outflow: $200,000, Discount rate: 15%, CF for year 1: $25,876, CF for year 2: $23,998, CF for year 3: $23,130, CF for year 4: $22,105, CF for year 5: $144,670. Draw your cash flow diagram and show your steps used in financial calculator. 2. Suppose you purchased an income producing property for...
1. Mia Salto wishes to determine how long it will take to repay a loan with...
1. Mia Salto wishes to determine how long it will take to repay a loan with initial proceeds of $5000 where annual end-of-year installment payments of $650 are required. a. If Mia can borrow at an annual interest rate of 7 %, how long will it take for her to repay the loan fully? b. How long will it take if she can borrow at an annual rate of 6 %? c. How long will it take if she has...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT