Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Will you help in the following bolded sections. Please provide as much detail as possible. Thank you. Statement of Cash Flows Date Ending Date Ending

Will you help in the following bolded sections. Please provide as much detail as possible. Thank you.

Statement of Cash Flows Date Ending Date Ending Date Ending Date Ending Date Ending
20## 20## 20## 20## 20##
Cash Flows From (For) Operations
Net Income $(109,585) $23,313 $69,538 $167,837 $205,088
Depreciation 2,848 4,880 3,485 2,489 1,780
Changes in Current Assets
Accounts Receivable (244,281) (65,897) (68,920) (82,541) (75,541)
Inventory (44,540) (78,631) 3,681 (42,006) 42,942
Changes in Current Liabilities
Accounts Payable - - - - -
Accrued Salaries and Wages 73,449 (73,449) - - -
Accrued Payroll Taxes and Benefits - - - - -
Cash From (For) Operating Activities $(322,109) $(189,783) $7,785 $45,780 $174,269
Cash Flow (For) From Investing Activities
Fixed Asset Purchases (69,142) 27,142 - - -
Short Term Investments - - - - -
Long Term Investments - - - - -
Net Cash Flows (For) From Investing $(69,142) $27,142 $- $- $-
Cash Flow From (For) Financing Activities
Issuance of Common Stock $- $- $- $- $-
Short Term Debt Borrowings - - -
Long Term Debt Borrowings - - - - -
Short Term Debt Payments - - - -
Long Term Debt Payments - - - - -
Dividends Paid to Stockholders - - - - -
Cash Flows From (For) Financing $- $- $- $- $-
Net Change in Cash $(391,251) $(162,641) $7,785 $45,780 $174,269
Beginning Cash Balance $- $(391,251) $(553,892) $(546,107) $(500,327)
Net Change in Cash $(391,251) $(162,641) $7,785 $45,780 $174,269
Ending Cash Balance $(391,251) $(553,892) $(546,107) $(500,327) $(326,059)
Date Ending Date Ending Date Ending Date Ending Date Ending Industry Average
2021 2022 2023 2024 2025 Ratios
Liquidity Ratios
Current Ratio
Quick Ratio
Operating Cycle
Leverage Ratios
Debt/Equity
Times Interest Earned
Asset Management Ratios
Inventory Turnover
Receivables Turnover
Fixed Asset Turnover
Profitability Ratios
Gross Profit Margin
Operating Profit Margin
Return on Assets
DuPont Analysis
Net Profit Margin
Total Asset Turnover
Equity Multiplier
Return on Equity
Pro Forma Income Statement Date Ending Date Ending Date Ending Date Ending Date Ending
2022 2023 2024 2025 2026
Sales Revenue $977,123 $1,240,712 $1,516,390 $1,846,553 $2,148,717
COGS $295,353.29 $376,883.94 $464,457.58 $548,492.58 $644,133.61
Gross Profit $681,770 $863,828 $1,051,932 $1,298,060 $1,504,583
General and Administrative Expenses
Salaries and Wages $309,000.00 $318,270.00 $358,318.10 $369,067.64 $410,639.67
Payroll Tax Expenses
Employee Benefits and Retirement $131,692.00 $131,692.00 $149,189.00 $149,189.00 $166,686.00
General Insurance Expense $30,256.00 $31,617.52 $33,040.31 $34,527.12 $36,080.84
Depreciation Expense $2,847.76 $4,880.46 $3,485.47 $2,489.05 $1,779.60
Rent Expense $42,000.00 $42,000.00 $42,000.00 $42,000.00 $42,000.00
Advertising and Promotion Expense $97,712.30 $124,071.20 $151,639.00 $184,655.30 $214,871.70
Taxes & Licenses $1,549.00 $600.00 $600.00 $600.00 $600.00
Office Expense (MOH) (Desks, chairs, etc.) $19,928.36
Utilities expense $10,168.21 $10,168.21 $10,168.21 $10,168.21 $10,168.21
Equipment Purchase $7,213.96 $0.00 $0.00 $0.00 $0.00
Outbound Transportation $123,986.94 $157,430.41 $192,415.58 $234,309.85 $272,646.79
Other - $0.00 $0.00 $0.00 $0.00 $0.00
Other - $0.00 $0.00 $0.00 $0.00 $0.00
Other - $0.00 $0.00 $0.00 $0.00 $0.00
Other - $0.00 $0.00 $0.00 $0.00 $0.00
Total General & Administrative Expenses $776,355 $820,730 $940,856 $1,027,006 $1,155,473
Earnings Before Interest and Taxes $(94,585) $43,098 $111,077 $271,054 $349,111
Interest Expense14 15,000 15,000 15,000 15,000 15,000
Earnings Before Taxes $(109,585) $28,098 $96,077 $256,054 $334,111
Income Tax Expense - 4,785 26,539 88,217 129,023
Net Income (Loss) $(109,585) $23,313 $69,538 $167,837 $205,088
Statement of Retained Earnings (NOT REQUIRED FOR DRAFT OR BUSINESS PLAN)
Beginning Balance of Retained Earnings $- $(109,585) $(86,272) $(16,734)
Net Income (Loss) (109,585) 23,313 69,538 167,837 205,088
Dividends to Stockholders - - -
Ending Retained Earnings $(109,585) $(86,272) $(16,734) $151,103 $205,088
Pro Forma Balance Sheet As of Inception Date Ending Date Ending Date Ending Date Ending Date Ending
Date 2022 2023 2024 2025 2026
ASSETS
44540.087
Current Assets
Cash and Cash Equivalents $188,907 $732,842.25 $930,534.00 $1,137,292.50 $1,384,914.75 $1,611,537.75
Accounts Receivable - $244,280.75 $310,178.00 $379,097.50 $461,638 $537,179.25
Inventory - 44,540 123,171 119,490 161,495 118,553
Short Term Investments - -
Total Current Assets $188,907 $1,021,663 $1,363,883 $1,635,880 $2,008,048 $2,267,270
Fixed (Long-Term) Assets
Machinery and Equipment $0.00 $7,213.96 - - - -
Office Equipment $0.00 $19,928.36 - - - -
Rent Expense $0 $42,000.00 $42,000.00 $42,000.00 $42,000.00 $42,000.00
Total Gross Fixed Assets $- $69,142.32 $42,000 $42,000 $42,000 $42,000
Less: Accumulated Depreciation - -$3,878.64 (6,647) (4,747) (3,390) (2,424)
Net Fixed Assets $- $65,264 $35,353 $37,253 $38,610 $39,576
Other Long Term Assets
Long Term Investments - - -
Intangibles, Net of Amortization - - - - - -
Total Other Long Term Assets $- $- $- $- $- $-
Total Assets $188,907 $1,086,927 $1,399,235 $1,673,132 $2,046,658 $2,306,846
LIABILITIES AND STOCKHOLDERS' EQUITY
Liabilities
Current Liabilities
Accounts Payable - -
Accrued Salaries and Wages - 73,449
Accrued Payroll Taxes and Benefits -
Notes Payable - 80,960
Current Maturity of LT Debt
Total Current Liabilities $154,409 $- $- $- $-
Long-Term Liabilities
LT Debt Less Current Maturities1 $- $- $- $- $-
Total Liabilities $- $154,409 $- $- $- $-
STOCKHOLDER'S EQUITY
Common Stock -
Retained Earnings 188,907 $921,749.25
Total Stockholders' Equity $188,907 $921,749 $- $- $- $-
Total Liabilities and Stockholders' Equity $188,907 $1,076,158 $- $- $- $-
1 Must adjust if Long Term Debt is used for Financing
$(10,768)

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

Managerial Accounting

Authors: John J Wild, Ken W. Shaw, Barbara Chiappetta

7th edition

1260482936, 978-1260482935

More Books

Students also viewed these Accounting questions

Question

Self-confidence

Answered: 1 week ago

Question

The number of people commenting on the statement

Answered: 1 week ago