Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Let's put NKE aside for this question. Suppose that you are a smaller, more niche player in the footwear market and you are expanding production.

Let's put NKE aside for this question. Suppose that you are a smaller, more niche player in the footwear market and you are expanding production. Use the information provided in the Part 2 box to forecast the 2021 balance sheet and any additional funds needed. You are projecting for 2021 (next year) and I have proved you with 2020 data (last year). Assume that you are operating at full capacity and that you are already planning a notes payable increase of $25 thousand. You do not currently plan to issue any equity or long-term debt. You are a young firm, so you do not pay an ongoing dividend. However, you do plan on making a $100 thousand "special dividend" payment to yourself and your other investors, which will come out of net income. Use the 2020 percentage of sales to forecast the other balance sheet items for 2021. Do your work in the box provided.

a) Given this information provided, does your firm need to raise additional funds? If so, how much?

Part 2 - AFN Forecasting
2020
Sales $ 4,000
Projected Sales Growth 25%
Projected Profit Margin 8%
Cash $125.00
Receivables $225.00
Inventories $300.00
Total current assets $650.00
Net fixed assets $900.00
Total assets $1,550.00
Accounts payable $75.00
Notes payable $55.00
Accruals $20.00
Total current liabilities $150.00
Long-Term Debt $350.00
Common stock $700.00
Retained earnings $350.00
Total liab. and equity $1,550.00
All numbers in thousands.

Please show all formulas in excel when doing calculations.

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

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

Accounting Principles Volume 1

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak

9th Canadian Edition

978-1119786818, 1119786819

More Books

Students also viewed these Accounting questions