Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SoGood Candy Company has been analyzing their financial statements to determine areas of inefficiency. As part of this analysis, the Finance Department is determining the

SoGood Candy Company has been analyzing their financial statements to determine areas of inefficiency. As part of this analysis, the Finance Department is determining the working capital, how the company is managing its receivables and payables, inventory and cash management.
The following information has been provided regarding the income statement and balance sheet for SoGood Candy Company for the past two years. Use this information to address the questions outlined below.
SoGood Candy Company
Income Statement (in Millions $)
For the Years ending Decemeber 31st
202X 202Y
Sales 68,000 77,000
COGS 52,000 61,000
Gross Profit 16,000 16,000
Selling & Gen Admin Expenses 6,000 8,000
Operating Profit 10,000 6,000
Interest expense 1,400 1,300
Earnings before Tax 8,600 4,700
Taxes 300 2,350
Earnings After Tax 8,300 2,350
SoGood Candy Company
Balance Sheet (in Millions $)
As of December 31st
202X 202Y 202X 202Y
Assets Liabilities
Cash 5,090 6,100 Accounts payable 2,700 3,700
Accounts receivable 3,000 6,900 Notes payable 1,180 1,250
Inventory 6,200 7,000 Accruals 5,600 6,211
Total Current Assets 14,290 20,000 Total current liabilities 9,480 11,161
Net plant, property & equipment 23,087 20,098 Long-term debt 6,500 7,000
Total Assets 37,377 40,098 Total Liabilities 15,980 18,161
Equity
Common Stock 2,735 2,735
Retained Earnings 1,552 17,902
Total Equity 4,287 20,637
Total Liabilities & Equity 20,267 38,798
Questions to Address for each year:
What is the company's net working capital?
202X
202Y
What is the company's Inventory Days Period?
202X days
202Y days
What is the company's Receivables Days Period?
202X days
202Y days
What is the company's Payables Days Period?
202X days
202Y days
What is the company's Cash Days Cycle?
202X days
202Y days
Based on the calculated data, what inferrences can you make about the efficiency of SoGood Candy Company?
Now that SoGood Candy Company knows its net working capital, they are exploring different projects. One project, which would add a new line of candy will require an investment of net working capital in the amount of $2.4 million. The company estimates that it will recover this net working capital amount over a 5 year period. The discount rate for this cash flow is 4%. What is the present value of the cost of working capital for this new line of candy?
Net Present Value (NPV):
SoGood Candy Company is evaluating its quarterly working capital needs. Using the information below, calcuate the working capital, permanent working capital, and temporary working capital needs for the company.
Quarter 1 2 3 4
Cash 708 890 670 1250
Accounts Receivable 450 750 1200 800
Inventory 650 550 700 400
Accounts Payable 900 850 1000 1145
Working capital
Permanent W/C
Temporary W/C
To meet the needs of temporary working capital, SoGood Candy Company has decided to issue commercial paper which will mature in 8 months. The commercial paper was issued for 1.6 millin and they received 1.5 million. What is the effective annual rate that they will pay for this loan?
Annual Percentage Rate(APR)
Effective Annual Rate (EAR)

Step by Step Solution

3.47 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

SOLUTION Here are the answers to the questions 1 What is the companys net working capital 202X 14290 202Y 20000 2 What is the companys Inventory Days ... 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

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

Entrepreneurial Finance

Authors: J. Chris Leach, Ronald W. Melicher

6th edition

1305968352, 978-1337635653, 978-1305968356

More Books

Students also viewed these Finance questions

Question

What does the coefficient of determination (R-squared) measure?

Answered: 1 week ago