Question
Can some one help me!! in Excel would be better and easy. thanks I appreciate in advance. Kindly!!! 1-KADS, Inc., has spent $350,000 on research
Can some one help me!! in Excel would be better and easy. thanks I appreciate in advance. Kindly!!!
1-KADS, Inc., has spent $350,000 on research to develop a new computer game. The firm is planning to -spend $150,000 on a machine to produce the new game. Shipping and installation costs of the machine will be capitalized and depreciated; they total $45,000. The machine has an expected life of three years, a $70,000 estimated resale value, and falls under the MACRS 7-year class life. Revenue from the new game is expected to be $550,000 per year, with costs of $200,000 per year. The firm has a tax rate of 40 percent, an opportunity cost of capital of 12 percent, and it expects net working capital to increase by $75,000 at the beginning of the project. What will the cash flows for this project be? (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.)
Year 0 1 2 3
FCF $ $ $ $
2-Compute the NPV for Project K if the appropriate cost of capital is 7 percent. (Negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your final answer to 2 decimal places.)
Time: 0 1 2 3 4 5
Cash Flow $11,600 $5,800 $6,800 $6,800 $5,800 $14,600
3-Suppose that TapDance, Inc.s, capital structure features 70 percent equity, 30 percent debt, and that its before-tax cost of debt is 6 percent, while its cost of equity is 11 percent. Assume the appropriate weighted average tax rate is 34 percent. What will be TapDances WACC? (Round your answer to 2 decimal places.) WACC %
4-Your firm needs a computerized machine tool lathe which costs $56,000 and requires $12,600 in maintenance for each year of its 3-year life. After three years, this machine will be replaced. The machine falls into the MACRS 3-year class life category. Assume a tax rate of 35 percent and a discount rate of 12 percent. If the lathe can be sold for $5,600 at the end of year 3, what is the after-tax salvage value? (Round your answer to 2 decimal places.) Salvage value after tax $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started