Calculate the irr and the payback period

Assignment Help Finance Basics
Reference no: EM131569438

Rick has been inspired by his sabbatical in DeKalb Illinois and has decided to open a Pizza Bagel restaurant. He was going to open a pizza shop, but seeing as he cannot find decent pizza in DeKalb he concludes that people in DeKalb do not like good pizza. However there is a decent bagel shop, so he adjusts his idea. Rick anticipates that the upfront costs for his equipment will be $45,000, and the CCA rate will be 20%. While Rick is enjoying DeKalb, he realizes that he is not at all suited to the midwest lifestyle just yet (he misses his lake and ocean), nor will he be for at least 25 more years, and that is how long he hopes that his Pizza Bagel shop will stay in business. At that time, the Salvage Value of the equipment he anticipates will be $20,000.

To help in his decision and his forecasts, Rick has hired a group of Dal CR MBA students which he has already paid $30,000 to for their consulting advice. Their analysis shows that the initial upfront working capital needs for the business will be $15,000 and thereafter will be 20% of total Sales. Rick expects to recover his investment in Net Working Capital when the shop closes up for good.

Rick plans to sell two different products; the Husky Pizza Bagel and the Mutt Pizza Bagel. First year unit sales of the Husky Bagel will be 9000 bagels, and the Mutt will have first year unit sales of 7000. The growth of unit sales is expected to increase 20% until year 5, at which time the unit growth will be 4% thereafter. The initial price of the Husky will be $5.00 and the Mutt will cost $4.50. Variable costs for the Husky are 60% of Sales, while variable costs for the Mutt are 30%. Price inflation is expected to be 3% per year. Fixed costs for the first year are expected to be $35,000 and Fixed Costs will increase with inflation.

The Pizza Shop will go into a building that Rick currently rents out to tenants for $20,000 per year. Rent is expected to increase with the inflation rate. Rick will kick out the current tenants and thus will not be able to have this rental income anymore. The tax rate is 25%, while the Discount Rate is 12%. (Note - a negative tax is counted for capital budgeting purposes as a negative number - this is due to the fact that any losses from the Pizza Bagel business will be used to reduce taxes in Rick's other businesses.)

Should Rick invest in the Pizza Shop? Beside the NPV, be sure to calculate the IRR and the Payback Period. Also you should prepare some scenario analysis as rumour has it that Rick believes in that type of analysis.

Reference no: EM131569438

Questions Cloud

What is the standard deviation of each stock : What is the standard deviation of each stock? What is the expected return on our portfolio?
What is the future value : What is the future value of $1,100, placed in a saving account for four years if the account pays 7.00%, compounded quarterly?
What is the future value of prize : What is the future value of this prize if each payment is put in an account earning 0.10?
Research report based on a hypothetical research study : Conducting research and writing a report is common practice for many students and practitioners in any of the behavioral sciences fields.
Calculate the irr and the payback period : Should Rick invest in the Pizza Shop? Beside the NPV, be sure to calculate the IRR and the Payback Period.
Write an argument essay about parents should limit the time : Write an argument essay about Parents should (should not) limit the amount of time that children spend on tech devices.
Summarize the current state of knowledge on your topic : Summarize the current state of knowledge on your topic, making reference to the findings of previous research studies .
Compute the firm price-earnings ratio : The company's share price is $13.74, and the company has 321,940 shares outstanding. Compute the firm's price-earnings ratio upto two decimal places.
Firm accounts receivables turnover : Flying Tigers, Inc., has net sales of $799,000 and accounts receivables of $163,000. What is the firm's accounts receivables turnover?

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd