Reference no: EM131192438
Jim Krakauer proposes to expand his restaurant supply business by adding an HVAC repair unit. Currently his customers, almost all restaurant owners, buy or order equipment from his sow room floor or from a warehouse of used equipment located behind his store. His new business would include a adding a fleet of ten cargo vans outfitted to the gills with shelving, tools, testing equipment and replacement parts. They would be driven by licensed HVACs capable of repairing everything from walk-in refrigerators to gas-fired stoves to the air conditioning system. The fleet of trucks itself would cost $500,000 and the cost of modifying them would be $600,000. Both of these costs are depreciable. Most truck fleet owners sell their trucks after they have been fully depreciated but Krakauer does not want to have his company’s logo on trucks that are old and beat up. His plan is to operate the fleet for five years only and then sell them at the end of five years. The entire depreciable amount would fall into the MACRS Five Year Class Life which extends beyond five years. Because the sale would be before they are fully deprecated some of the gain would be shielded from taxes by the residual book value. He hopes he can get a salvage value from the sale of the fleet in the amount of $90,000
Krakauer anticipates revenues of $2,300,000 per year from the venture. Operating costs (i.e. cost of goods sold) including driver/HVACs wages and the after-market parts sold to customers would amount to $1,839,600 per year. He expects his receivables period will be 45 days of sales; inventories on the trucks would amount to 30 days of operating costs and his business pays its bills to vendors on average 22 days after receiving delivery so the payables period would be 22 days on a cost of goods sold basis. His cost of capital is 12% and his tax rate (state, local, federal) is 33.33%
Evaluate this proposal using the capital budgeting criteria, NPV, IRR, MIRR, PI, Payback and Discounted Payback.
OF PARTICULAR INTEREST IS WHAT INPUTS FEED THIS MODEL -- Please solve in Excel format
|
What is the dollar price of the bond
: Union Local School District has bonds outstanding with a coupon rate of 4.7 percent paid semiannually and 22 years to maturity. The yield to maturity on these bonds is 4.1 percent and the bonds have a par value of $10,000. What is the dollar price of..
|
|
What will its approximate value be five years from now
: Ben Collins plans to buy a house for $150,000. If the real estate in his area is expected to increase in value by 1 percent each year, what will its approximate value be five years from now?
|
|
Reported free cash flows
: Free Cash Flow Iron Ore Corp. reported free cash flows for 2008 of $106 million and investment in operating capital of $189 million. Iron Ore listed $39 million in depreciation expense and $51 million in taxes on its 2008 income statement. What was I..
|
|
About purchasing new sand-casting equipment
: Jetson Foundry is thinking about purchasing new sand-casting equipment that would reduce the time and cost of grinding customer orders to tolerance. The new equipment will cost $70,000 and it will take $15,000 to modify it for company needs. Evaluate..
|
|
Proposes to expand his restaurant supply business
: Jim Krakauer proposes to expand his restaurant supply business by adding an HVAC repair unit. Currently his customers, almost all restaurant owners, buy or order equipment from his sow room floor or from a warehouse of used equipment located behind h..
|
|
What was your realized real return
: Suppose you earned a nominal 5% on your bank savings deposit, and actual inflation was 3.5%. What was your realized real return? If you had expected inflation to be 3%, what is your realized gain or loss in purchasing power versus what you expected?
|
|
We are talking about historical cost principle
: How to respond to this comment? We are talking about historical cost principle? Yes when a company holds the value of real estate over years it is going to do nothing but appreciate. As you said referring to machinery vs real estate items like that w..
|
|
The firm use to discount the project cash flows
: Titan Mining Corporation has 9.8 million shares of common stock outstanding and 420,000 5 percent semiannual bonds outstanding, par value $1,000 each. What is the firm's market value capital structure? If the company is evaluating a new investment pr..
|
|
Discuss the motivations behind the unethical behavior
: UBS and Morgan Stanley: An Elaborate Insider Trading Scheme. After reading the case discuss the motivations behind the unethical behavior, who was hurt by the unethical behavior, and explain the context and conditions that are thought to contribute t..
|