Question: need help solving this in excel show work and explain how you got answers please. Intro Your selfie stick business is languishing. To give it

need help solving this in excel show work and explain how you got answers please.
Intro Your selfie stick business is languishing. To give it a boost, you've decided to run an ad campaign, either on television or on the radio If you run a television campaign, it will cost you $200,000 now (quarter O) to create the video ads. You project increased cash flows of $10,000 in the first quarter, which will grow at a rate of 23% until quarter 8, after which incremental cash flows will be $2,000 every quarter forever. If you run a radio campaign, it will cost you only $30,000 now to create the radio ads. You project increased cash flows of $20,000 in the first quarter which will grow at a rate of 2% until quarter 8, after which incremental cash flows will be $2,000 every quarter forever. Your annual discount rate is 13% Part 1 Attempt 1/30 for 10 pts. What is the cash flow in quarter 8 of the television campaign? 0+ decimals Submit Part 2 Attempt 1/30 for 10 pts What is the present value of the terminal value of the television campaign? 0+ decimals Submit Attempt 1/30 for 10 pts. Part 3 What is the NPV of the television campaign? 0+ decimals Submit Attempt 1/30 for 10 pts. Part 4 What is the NPV of the radio campaign? 0+ decimals Submit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
