Problem 12-6 Spreadsheet Problem: Project Cash Flows (LG12-3) KADS, Incorporated has spent $430,000 on research to develop a new computer game. The firm is planning to spend $230,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 $53,000. The machine has an expected life of three years, a $78,000 estimated resale value, and falls under the MACRS seven-year class life. Revenue from the new game is expected to be $630,000 per year, with costs of $280,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 $115,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 decimal places. Answer is complete but not entirely correct. FCF Year 0 1 2 $ (398,000.00) S 284,992.55 $ 291,054.41 3 470,285.57

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
Problem 12-6 Spreadsheet Problem: Project Cash Flows (LG12-3)
KADS, Incorporated has spent $430,000 on research to develop a new computer game. The firm is planning to spend $230,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 $53,000. The machine has an expected life of three years, a $78,000 estimated resale value, and falls under
the MACRS seven-year class life. Revenue from the new game is expected to be $630,000 per year, with costs of $280,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
$115,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 decimal places.
Answer is complete but not entirely correct.
FCF
Year
0
1
2
$
(398,000.00)
S
284,992.55
$
291,054.41
3
470,285.57
Transcribed Image Text:Problem 12-6 Spreadsheet Problem: Project Cash Flows (LG12-3) KADS, Incorporated has spent $430,000 on research to develop a new computer game. The firm is planning to spend $230,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 $53,000. The machine has an expected life of three years, a $78,000 estimated resale value, and falls under the MACRS seven-year class life. Revenue from the new game is expected to be $630,000 per year, with costs of $280,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 $115,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 decimal places. Answer is complete but not entirely correct. FCF Year 0 1 2 $ (398,000.00) S 284,992.55 $ 291,054.41 3 470,285.57
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education