Calculate the npv profitability index irr mirr

Assignment Help Finance Basics
Reference no: EM13230170

Frozen Turkeys Scenario 
Cost of Land $ 200,000 
Cost of Buildings & Equipment $ 350,000 
MACRS Class 20 
Life of Project (Years) 5 
Terminal Value of Land $ 300,000 
Terminal Value of Buildings & Equipment $ 175,000 
First year sales (pounds) 250,000 
Price per Pound $3.50 
Unit Sales Growth Rate 7.0% 
Variable Costs as % of Sales 62% 
Fixed Costs 75,000 
Tax Rate 35% 
WACC 10.0% 

a. Prepare a statement of annual cash flows for years 0 through 5. Cash flows in year 0 are your expenses for building and land. 
Sales growth is based on the annual growth rate in units. 
Assume no changes in fixed or variable costs. 
Depreciate the project cost for 5 years, with the cash flow in year 5 to include the terminal cash flow of ending the investment. 

b. Calculate the NPV, profitability index, IRR, MIRR, payback and discounted payback of the cash flows in part 1. 

c. Using scenario manager find best case, worst case, base case of NPV based on sales in pounds, price per pound, and variable cost percent. Make sure to include scenario summary.

Reference no: EM13230170

Questions Cloud

Fishhook just went public and is considering a bond issue : FishHook (FH) just went public and is considering a bond issue with warrants attached
What are the limits that the actual value will fall under : an analog ammeter and the faceplate states an accuracy of +/- 1.5% of full scale value. if we take a measurement on the 10A scale and we measure 1.8A, what are the limits that the actual value will fall under.
What is the optimal oil exploration strategy : Assuming that prospecting and drilling take no time, what is the optimal oil exploration strategy for the firm (that is, where should it prospect, and when should it drill)?
Strategically identify new market opportunities : Market research and a competitive analysis are typically used in order to determine the feasibility of a new technology. How you could use advanced market research in order to remain competitive
Calculate the npv profitability index irr mirr : Calculate the NPV, profitability index, IRR, MIRR, payback and discounted payback of the cash flows in part 1.
What is the reorder point : The injection molding department of a company that operates 24x7 uses an average of 20 gallons of special lubricant per day. It takes two weeks for an order of lubricant to be delivered.
How will this influence the new store coordinates : Census tracts 103 and 105 are each projected to grow by 20% in the next year. How will this influence the new store's coordinates?
Determine what is the instantaneous voltage at t of signal : An AC signal has a peak value of 100 V and a frequency of 60 Hz. If the voltage crosses zero in a rising direction at t=0 seconds, what is the instantaneous voltage at t = 0.004167
Determine what is the mmf of the solenoid in ampere-turns : A 800 turn solenoid has a total wire length of 400 feet of AWG 24 copper wire. This wire has a resistance of 26.17 ohms per 1000 feet. The voltage measured from one end of the solenoid to the other is 21 volts. What is the mmf of the solenoid in a..

Reviews

Write a Review

Finance Basics Questions & Answers

  Determine the risk involved with each plan

DeSoto Tools, Corporation is considering to expand production. The expansion will cost $300,000, which can be financed either by bonds at an interest rate of 14% or through selling 10,000 shares of common stock at $30 per share.

  Discuss three major cross-cultural differences

large Businesses and small now compete in a truly global economy. To become successful in another nation it is essential to understand cultural differences that exist.

  Fisher effect-us and euro inflation and currency rates

Assume that the U.S and the Euro nominal interest rate are equal. Subsequently, the U.S. nominal rate decreases while the Euro nominal interest rate remains stable.

  Calculate the net cash provided by operating activities

King Company makes a short-term investment in 300 shares of Renfro Corporation's common stock. The stock is purchased for $30 a share plus brokerage fees of $400.

  Define strips

A call provision on a bond allows the issuer to redeem the bond at will. Investors do not like call provisions and so require higher interest on callable bonds.

  Compute the unit product cost under absorption costing

The Bohne Corporation produces chocolate candies. The chocolates sell for $12 per box. Yearly, the firm produces 10,000 boxes of chocolates and sells 9,000 boxes of the candies.

  Costs-bond issues

Compute the cost of repricing the bond issue. Give the expected additional cost associated with recommendation of pricing the issue to yield the more competitive return.

  Find the stock expected price today

Suppose that the expected future dividends (D) at end of periods 1,2, and 3, as well as the expected future price (P) at end of period 3 for a stock are as given: D1 = $1.20, D2 = $1.40, D3 = $1.55, and P3 = $80.00.

  Market capitalization rate

The stock chosen is Johnson Controls INC. The computations should be done in excel. Please answer the following questions.

  Determinig annual installments

What if you make the first payment on loan immediately instead of at the end of first year?

  Compute the sales tax

Suppose you are shopping for office supplies and furnishings for your corporation, Financial Outsourcing, Corporation Use the comparative shopping web search engines in the Library to conduct the following research.

  Estimating net present value

Income from a precious metals mining operation has been decreasing uniformly for five years. If income in year one was $100,000 and it decreased by $10,000 per year through year five,

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