Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the AFNWC (additional funds needed for working capital) with the information below: ************************YEAR T+1 Revenues $5,700.00 COGS $4,560.00 Gross Profit $1,140.00 Operating Expenses $500.00

Calculate the AFNWC (additional funds needed for working capital) with the information below:

************************YEAR T+1

Revenues $5,700.00

COGS $4,560.00

Gross Profit $1,140.00

Operating Expenses $500.00

Depreciation $27.00

EBIT $613.00

Interest Expense $35.00

EBT $578.00

Taxes $231.20

NI $ 346.80

Dividends $ 0.00

RE $346.80

************************Balance Sheet YEAR T+1 YEAR T

Cash and Equivalents $714.80 $120.00

Accounts Receivable $500.00 $500.00

Inventory $300.00 $340.00

Total Current Assets $1,514.80 $960.00

Fixed Assets $660.00 $800.00

Accumulated Depreciation $227.00 $200.00

Net Fixed Assets $433.00 $600.00

Total Assets $1,947.80 $1,560.00

Accounts Payable $320.00 $300.00

Short-Term Notes Payable $40.00 $50.00

Accruals $11.00 $10.00

Total Current Liabilities $371.00 $360.00

Long-Term Debt $780.00 $750.00

Total Liabilities $1,151.00 $1,110.00

Common Stock $120.00 $120.00

Retained Earnings $676.80 $330.00

Total Shareholders Equity $796.80 $450.00

Total Liabilities & Shareholders Equity $ 1,947.80 $1,560.00

************************Formula:

AFN = (A*/S0)S (L*/S0)S MS1(RR)

A- Assets tied directly to sales

L-spontaneous liabilities that are affected by sales

S0=the previous year's sales

S1=total projected sales for next year

S=the change in sales between S0 and S1

M=profit margin

MS1=projected net income

RR=the retention ratio from net income (equal to 1 minus the dividend payout ratio; disregard if dividends are not declared).

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

Funds Private Equity Hedge And All Core Structures

Authors: Matthew Hudson

1st Edition

1118790405, 978-1118790403

More Books

Students also viewed these Finance questions

Question

7. What decisions would you make as the city manager?

Answered: 1 week ago

Question

8. How would you explain your decisions to the city council?

Answered: 1 week ago