Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your group works in the Corporate Finance department of Dogwood Winery. Management is considering releasing a new line of wines and has asked you to

Your group works in the Corporate Finance department of Dogwood Winery. Management is considering releasing a new line of wines and has asked you to conduct an analysis of the project. You will be presenting your results to senior management.

The new wines sell for $35 per litre and have a variable cost of $11 per litre. The company has conducted a marketing study which cost the company $69,500, and the study suggested that sales will be 58,000 litres per year for the next nine years.

Given the popularity of the new wines, the marketing study also expected that sales of its luxury ros wines will decline by 50,000 per year. The luxury ros wines sell for $180 per litre and have variable costs of $68 per litre. The company will also increase sales of its inexpensive red wines by 65,000 litres per year. The inexpensive red wines sell for $12 per litre and have variable costs of $10 per litre. The fixed costs each year will be $520,000.

A famous actor has agreed to sponsor the new line of wines and to defer payment until the year after the company reached sales of $12,180,000 cumulatively. Payment for sponsorship would be a one-time payment of $89,000. The company also spent 62,000 on research and development for the new wines.

New equipment to manufacture the new line of wines is $880,000 and qualify for depreciation at a CCA rate of 33 percent. The new line of wines will also need an incremental new working capital of $960,000 that will be returned at the end of the project. The tax rate is 23 percent, and the cost of capital is 16 percent. Assets will remain in the CCA class after the end of the project.

Required: Calculate the payback period and the NPV. Provide a recommendation for senior management. Should the company proceed with the project?

Your manager has asked for the following components:

  1. An Excel spreadsheet showing detailed calculations of each component of the cash flow analysis for each year of the project horizon. Show the payback period and NPV calculation in the spreadsheet.

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_2

Step: 3

blur-text-image_3

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

Auditing A Business Risk Approach

Authors: Karla Johnstone, Audrey Gramling, Larry Rittenberg

8th edition

538476230, 978-0538476232

More Books

Students also viewed these Finance questions

Question

How have computers benefited marketing and sales offices?

Answered: 1 week ago

Question

=+2. Explain the interactions in the newspaper and magazine market!

Answered: 1 week ago