Instructions Wagner Chocolates makes a variety of chocolate candies. They are considering adding cupcakes to their menu of sweet treats. Because they are already producing at capacity, the company would need to add space and equipment. There is suitable bakery space available for rent adjacent to their current production facility. The rent would be $1,000 per month (fixed.) Wagner would also need to add ovens and other equipment at a cost of 42,000. This equipment is expected to have a useful life of four years, and for purposes of this analysis, 4 years is also the life of the project. Wagner expects the salvage value of the equipment to be zero at the end of four years. Each cupcake will sell for $2.50. Variable costs (DM, DL VFO) are expected to be $1.58 per cupcake. Wagner anticipates selling nine dozen cupcakes per day, 5 days a week, 52 weeks per year. Wagner requires a minimum rate of return on investment of 8%. 1. Create an Excel spreadsheet and enter all of the given information. This part of your spreadsheet should be highlighted in a different color and is the only place in the spreadsheet where you may enter numbers. 2. Construct an income statement that includes Sales, Cost of Goods Sold, Gross Profit, Operating Expenses, and Net Income for the proposed cupcake division. Don't enter any numbers in this section; use only formulas and cell references (referring to the cells from part 1.) *You will need to calculate depreciation on the equipment and include it as an operating expense. Consider the rent an operating expense as well. Also, calculate the annual net cash inflow from the project, which will be different from the Net Income. 3. Evaluate the proposed project by calculating the following: 。 Accounting Rate of Return 。 Cash Payback period • Net Present Value • Internal Rate of Return Again, do not enter any numbers here. Use only formulas and cell references. (The only exception is that you may enter the factor from the PV table.) 4. Add a text box and explain whether this project should be undertaken based on the results of part 3.
Instructions Wagner Chocolates makes a variety of chocolate candies. They are considering adding cupcakes to their menu of sweet treats. Because they are already producing at capacity, the company would need to add space and equipment. There is suitable bakery space available for rent adjacent to their current production facility. The rent would be $1,000 per month (fixed.) Wagner would also need to add ovens and other equipment at a cost of 42,000. This equipment is expected to have a useful life of four years, and for purposes of this analysis, 4 years is also the life of the project. Wagner expects the salvage value of the equipment to be zero at the end of four years. Each cupcake will sell for $2.50. Variable costs (DM, DL VFO) are expected to be $1.58 per cupcake. Wagner anticipates selling nine dozen cupcakes per day, 5 days a week, 52 weeks per year. Wagner requires a minimum rate of return on investment of 8%. 1. Create an Excel spreadsheet and enter all of the given information. This part of your spreadsheet should be highlighted in a different color and is the only place in the spreadsheet where you may enter numbers. 2. Construct an income statement that includes Sales, Cost of Goods Sold, Gross Profit, Operating Expenses, and Net Income for the proposed cupcake division. Don't enter any numbers in this section; use only formulas and cell references (referring to the cells from part 1.) *You will need to calculate depreciation on the equipment and include it as an operating expense. Consider the rent an operating expense as well. Also, calculate the annual net cash inflow from the project, which will be different from the Net Income. 3. Evaluate the proposed project by calculating the following: 。 Accounting Rate of Return 。 Cash Payback period • Net Present Value • Internal Rate of Return Again, do not enter any numbers here. Use only formulas and cell references. (The only exception is that you may enter the factor from the PV table.) 4. Add a text box and explain whether this project should be undertaken based on the results of part 3.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Instructions
Wagner Chocolates makes a variety of chocolate candies. They are considering adding cupcakes to their menu of sweet treats.
Because they are already producing at capacity, the company would need to add space and equipment. There is suitable bakery space
available for rent adjacent to their current production facility. The rent would be $1,000 per month (fixed.) Wagner would also need
to add ovens and other equipment at a cost of 42,000. This equipment is expected to have a useful life of four years, and for
purposes of this analysis, 4 years is also the life of the project. Wagner expects the salvage value of the equipment to be zero at the
end of four years. Each cupcake will sell for $2.50. Variable costs (DM, DL VFO) are expected to be $1.58 per cupcake. Wagner
anticipates selling nine dozen cupcakes per day, 5 days a week, 52 weeks per year. Wagner requires a minimum rate of return on
investment of 8%.
1. Create an Excel spreadsheet and enter all of the given information. This part of your spreadsheet should be highlighted in a
different color and is the only place in the spreadsheet where you may enter numbers.
2. Construct an income statement that includes Sales, Cost of Goods Sold, Gross Profit, Operating Expenses, and Net Income for
the proposed cupcake division. Don't enter any numbers in this section; use only formulas and cell references (referring to the
cells from part 1.) *You will need to calculate depreciation on the equipment and include it as an operating expense. Consider
the rent an operating expense as well. Also, calculate the annual net cash inflow from the project, which will be different from
the Net Income.
3. Evaluate the proposed project by calculating the following:
。 Accounting Rate of Return
。 Cash Payback period
• Net Present Value
• Internal Rate of Return
Again, do not enter any numbers here. Use only formulas and cell references. (The only exception is that you may enter the
factor from the PV table.)
4. Add a text box and explain whether this project should be undertaken based on the results of part 3.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2dc5bcd4-ace2-4254-ac5a-39e6342c69f7%2Ff7498dc3-e73c-4c74-81a5-0601979678db%2Fnm3yw9_processed.png&w=3840&q=75)
Transcribed Image Text:Instructions
Wagner Chocolates makes a variety of chocolate candies. They are considering adding cupcakes to their menu of sweet treats.
Because they are already producing at capacity, the company would need to add space and equipment. There is suitable bakery space
available for rent adjacent to their current production facility. The rent would be $1,000 per month (fixed.) Wagner would also need
to add ovens and other equipment at a cost of 42,000. This equipment is expected to have a useful life of four years, and for
purposes of this analysis, 4 years is also the life of the project. Wagner expects the salvage value of the equipment to be zero at the
end of four years. Each cupcake will sell for $2.50. Variable costs (DM, DL VFO) are expected to be $1.58 per cupcake. Wagner
anticipates selling nine dozen cupcakes per day, 5 days a week, 52 weeks per year. Wagner requires a minimum rate of return on
investment of 8%.
1. Create an Excel spreadsheet and enter all of the given information. This part of your spreadsheet should be highlighted in a
different color and is the only place in the spreadsheet where you may enter numbers.
2. Construct an income statement that includes Sales, Cost of Goods Sold, Gross Profit, Operating Expenses, and Net Income for
the proposed cupcake division. Don't enter any numbers in this section; use only formulas and cell references (referring to the
cells from part 1.) *You will need to calculate depreciation on the equipment and include it as an operating expense. Consider
the rent an operating expense as well. Also, calculate the annual net cash inflow from the project, which will be different from
the Net Income.
3. Evaluate the proposed project by calculating the following:
。 Accounting Rate of Return
。 Cash Payback period
• Net Present Value
• Internal Rate of Return
Again, do not enter any numbers here. Use only formulas and cell references. (The only exception is that you may enter the
factor from the PV table.)
4. Add a text box and explain whether this project should be undertaken based on the results of part 3.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education