Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you please show me how to do this in excel with the cell showing how you did this, please not a write discription im

can you please show me how to do this in excel with the cell showing how you did this, please not a write discription im a visual learner. thank you so much
image text in transcribed
image text in transcribed
image text in transcribed
7 8 P12-14 Modified (use the template below for problem setup) As part of its planning for the coming Christmas season, Criswell Motorsports is considering whether to expand its product line that Currently consists of skateboards to include gas powered skateboards. The company feels it can sell 2,500 of these per year for 10 years after which time this project is expected to shut down, with solar powered skateboards taking over). Each gas-powered skateboard would have variable costs of $100 and sell for $225, annual fixed costs associated with production would be $235.000. In addition, there would be a $525,000 initial expenditure associated with the purchase of new production equipment. It is assumed that the simplified straight line method would be used to depreciate this initial expenditure down to zero over 10 years. The project would 9 also require a one-time initial investment of $75,000 in net working capital associated with inventory, and this working capital 10 investment would be recovered when the project is shut down. Finally, assume that the firma's marginal tax rate is 26% 11 a. What is the initial cash outloy associated with this project? 12 . What are the annual net cash flows associated with this project for years 1-97 13 c. Whet lathe terminal cash flow in year 10 (that is what is the free cash flow in year 10 plus any additional cash flows associated with the termination of the project?) 14 15 d. What is the projects NPV given a 12% required rute of return? 16 17 18 INPUTS (in Blue: 19 Tax Rate 20 Required Rate of Return 21 Years 22 Cost of the New Equipment 23 Initial Working Capital 24 Annet Sol TS dalam AUS tale 3 ARRI Ald IGO Cash 43 Am 45 h the late WC DOMOS PM Hy WO TOR ter P. MacBook Pro

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Middle Market M And A Handbook For Advisors Investors And Business Owners

Authors: Kenneth H. Marks, Christian W. Blees, Michael R. Nall, Thomas A. Stewart

2nd Edition

1119828104, 978-1119828105

More Books

Students also viewed these Finance questions

Question

Describe how we perceive depth in three-dimensional space.

Answered: 1 week ago