Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show how you got your answer. im still a little new to excel. If you do both questions i would be forever grateful and

image text in transcribedimage text in transcribed

please show how you got your answer. im still a little new to excel. If you do both questions i would be forever grateful and make sure you get at least three thumbs up:)

B D E F G H I 6 Catzz Corp is considering making and selling Trolls' themed cat sweaters. 7 Catzz expects to sell the sweaters for $35 each; this project is expected to last three years due to changes in popular movies. 8 Catz will need to buy equipment costing $100,000; this equipment will use the new 2018 tax laws so will have bonus depreciation year 1. 9 Variable costs are expected to be $20 each sweater; this includes both material costs and licensing fees to Dreamworks. 10 Fixed costs are expected to be $55,000 a year which includes advertising and management costs. 11 Catzz expects to sell 4,000 sweaters in the first year, 6,000 and 8000 sweaters the third year. 12 At the end of the third year, Catzz will end the project and believes it can sell the machine for $40,000 despite the machine's zero book value (due to 2018 tax laws). 13 Net working capital needs are $10,000 in year 0 and 10% of revenues in years 1-3. Net working capital will be liquidated in year 3. 14 Catzz has a marginal tax rate of 21% and this project has a required rate of 12% due to its high risk. (Assume Catzz is a very profitable company which can take tax credits when EBIT is less than zero.) 15 Assume Catzz is a very profitable company which can take tax credits when EBIT is less than zero. 16 Information from above in table form: 17 Cost of equipment year 0 $ 100,000 installed 18 Bonus depreciation on equipment 19 Expect to sell equipment for $ 40,000 in year 3 20 Year year 1 year 2 21 Quantity sold per year 0 4000 6000 8000 22 Price $ 35.00 per sweater 23 Variable costs $20.00 per sweater 24 Fixed costs $ 55,000.00 per year 25 Net working capital year 0 10000 year o 26 Net working years 1-3 10% of revenues 27 Net working capital will be liquidated in year 3 28 Catzz marginal tax rate 21% 29 Required rate on project 12% year 3 B D E 1 2 3 49 5. Set up the Net Working Capital Cash Flows for years 0-3: 50 Year 0 51 Revenue 52 Initial net working capital requirement 53 Net Working capital needs 54 Liquidation of net working capital 55 Cash flow net working capital* 56 6. Set up the free cash flows of the project 57 Year 0 58 Operating Cash Flow 59 Net Working capital cash flow* 60 Capital Spending cash flow* 61 Free Cash Flow 62 7. a. What is the Net Present Value of the Troll themed cat sweater project? 1 2 3 B D E F G H I 6 Catzz Corp is considering making and selling Trolls' themed cat sweaters. 7 Catzz expects to sell the sweaters for $35 each; this project is expected to last three years due to changes in popular movies. 8 Catz will need to buy equipment costing $100,000; this equipment will use the new 2018 tax laws so will have bonus depreciation year 1. 9 Variable costs are expected to be $20 each sweater; this includes both material costs and licensing fees to Dreamworks. 10 Fixed costs are expected to be $55,000 a year which includes advertising and management costs. 11 Catzz expects to sell 4,000 sweaters in the first year, 6,000 and 8000 sweaters the third year. 12 At the end of the third year, Catzz will end the project and believes it can sell the machine for $40,000 despite the machine's zero book value (due to 2018 tax laws). 13 Net working capital needs are $10,000 in year 0 and 10% of revenues in years 1-3. Net working capital will be liquidated in year 3. 14 Catzz has a marginal tax rate of 21% and this project has a required rate of 12% due to its high risk. (Assume Catzz is a very profitable company which can take tax credits when EBIT is less than zero.) 15 Assume Catzz is a very profitable company which can take tax credits when EBIT is less than zero. 16 Information from above in table form: 17 Cost of equipment year 0 $ 100,000 installed 18 Bonus depreciation on equipment 19 Expect to sell equipment for $ 40,000 in year 3 20 Year year 1 year 2 21 Quantity sold per year 0 4000 6000 8000 22 Price $ 35.00 per sweater 23 Variable costs $20.00 per sweater 24 Fixed costs $ 55,000.00 per year 25 Net working capital year 0 10000 year o 26 Net working years 1-3 10% of revenues 27 Net working capital will be liquidated in year 3 28 Catzz marginal tax rate 21% 29 Required rate on project 12% year 3 B D E 1 2 3 49 5. Set up the Net Working Capital Cash Flows for years 0-3: 50 Year 0 51 Revenue 52 Initial net working capital requirement 53 Net Working capital needs 54 Liquidation of net working capital 55 Cash flow net working capital* 56 6. Set up the free cash flows of the project 57 Year 0 58 Operating Cash Flow 59 Net Working capital cash flow* 60 Capital Spending cash flow* 61 Free Cash Flow 62 7. a. What is the Net Present Value of the Troll themed cat sweater project? 1 2 3

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

Corporate Finance Principles And Practice

Authors: Denzil Watson, Tony Head

1st Edition

0273630083, 978-0273630081

More Books

Students also viewed these Finance questions

Question

Explain the concept of an entrepreneurial legacy. LO.1

Answered: 1 week ago

Question

=+a) Create a run chart for the baseballs circumferences.

Answered: 1 week ago

Question

If you were Akio, what would you do now?

Answered: 1 week ago