Reference no: EM131192431
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.
Please solve in Excel format
|
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..
|
|
Procedure projected in the flexible budget estimate
: The controller of the Conrad Aiken Surgical Center was reviewing monthly financial reports and noted some differences. The center had fallen 8 short of its plan to perform 450 procedures during the month. what was the total revenue per procedure proj..
|
|
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..
|
|
Proposal using the capital budgeting criteria
: 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..
|
|
The firm achieve in order to meet its growth rate goal
: Fulkerson Manufacturing wishes to maintain a sustainable growth rate of 9.5 percent a year, a debt–equity ratio of .39, and a dividend payout ratio of 33 percent. The ratio of total assets to sales is constant at 1.36. What profit margin must the fir..
|
|
Common stock value-constant growth
: The common stock of Denis and Denis Research Inc. Trades for $60 per share. Investors expect the company to pay a $3.90 dividend next year, and they expect that dividend to grow at a constant rate forver. If investors require a 10% return on this sto..
|
|
What is the amount of the firm net fixed assets
: The Caughlin Company has a long-term debt ratio of 0.45 and a current ratio of 1.25. Current liabilities are $987, sales are $6,860, profit margin is 8.6 percent, and ROE is 17.5 percent. What is the amount of the firm's net fixed assets?
|
|
What were total liabilities-long-term debt financing
: At year-end 2016, Wallace Landscaping’s total assets were $1.0 million and its accounts payable were $340,000. Sales, which in 2016 were $2.2 million, are expected to increase by 30% in 2017. Total assets and accounts payable are proportional to sale..
|