Question: Problem 1 2 - 6 Spreadsheet Problem: Project Cash Flows ( LG 1 2 - 3 ) KADS, Incorporated has spent $ 4 9 0

Problem 12-6 Spreadsheet Problem: Project Cash Flows (LG12-3)
KADS, Incorporated has spent $490,000 on research to develop a new computer game. The firm is planning to spend $290,000 on a machine to produce the new game. Shipping and installation costs of the machine will be capitalized and depreciated using bonus depreciated; they total $59,000. The machine has an expected life of three years, a $84,000 estimated resale value, and falls under the MACRS seven-year class life. Revenue from the new game is expected to be $690,000 per year, with costs of $340,000 per year. The firm has a tax rate of 21 percent, has an opportunity cost of capital of 12 percent, and expects net working capital to increase by $145,000 at the beginning of the project.
What will the cash flows for this project be?
Note: Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.
\table[[Year,,0,1,,2,3],[FCF,$,(145,000.00),,$,(70,801.00),(50,601.00)
 Problem 12-6 Spreadsheet Problem: Project Cash Flows (LG12-3) KADS, Incorporated has

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!