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

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

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!