Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Forecast financial statements for Cadbury for Year 3 using the assumptions below, and answer the questions that follow. You can also find the data in

Forecast financial statements for Cadbury for Year 3 using the assumptions below, and answer the questions that follow. You can also find the data in the file "AGB311 HW5 template.xlsx".
Sales growth of 18%.
The cost of debt is 2.98% of last period's long-term debt.
The tax rate is 30%.
The depreciation rate is 15%.
CAPEX is 290 million.
The following accounts are held constant: Intangible Assets and Common Stock.
Long-term debt is the PLUG variable.
No dividends.
Cost of Goods Sold/Sales
0.569135
SG&A/Sales
0.257552
Current Assets/Sales
0.499741
Current Liabilities/Sales
0.586397
Past financial statements for Cadbury are shown here:
Cadbury Income Statement and Balance Sheet
As of December 31, Year 1 & 2
( millions)
Year 2
Revenue
5793
Cost of Goods Sold
3297
SG&A
1492
Depreciation Expense
186
EBIT
818
Interest expenses
55
Earnings before taxes
763
Income taxes
34
Net Income
729
ASSETS
Year 1
Year 2
Total current assets
2665
2895
Property, plant and equipment
1900
1753
Intangible assets
6764
4220
Total Assets
11329
8868
LIABILITIES & STOCKHOLDERS' EQUITY
Total current liabilities
4616
3397
Long-term debt
2535
1927
Total Liabilities
7151
5324
Stockholders' Equity
Common Stock
1495
1043
Retained earnings
2683
2501
Total Stockholders' Equity
4178
3544
Total Liabilities & Stockholders' Equity
11329
8868
From the forecasted financial statements, the additional funds needed(AFN) in Year3 are_________millions. (The AFN is the change in the plug account from Year 2 to Year3.)(Round to the whole number.) Using the equation approach, the AFN in Year3 are _______ million. (Round to the whole number.) Hint: A* refers to total current assets and PPE; L* refers to total current liabilities. The maximum internal growth rate for Cadbury is ________ percent. (Round to two decimal places.) Hint: use numbers from year 2. The maximum sustainable growth rate for Cadbury is ________ percent. (Round to two decimal places.) Hint: use numbers from year 2.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Linear Algebra A Modern Introduction

Authors: David Poole

3rd edition

978-0538735452

Students also viewed these Finance questions

Question

What is the meaning and definition of E-Business?

Answered: 1 week ago