Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

FY 1 2 / 3 1 FY 1 2 / 3 2 FY 1 2 / 3 3 FY 1 2 / 3 4 FY

FY 12/31 FY 12/32 FY 12/33 FY 12/34 FY 12/35 FY 12/36 FY 12/37 FY 12/38
20222023E
Revenue 130,000,000100.0% Revenue 25%162,500,000162,500,000100.0%
Cost of Goods Sold 58,500,00045.0%0.0%1.5
Gross Profit 71,500,00055.0% G. Margins 1.0%0.0%2.0
Sales and Marketing (S&M)26,000,00020.0% S&M 1.0%(CSB)0.0%2.0
General and Admin 14,300,00011.0% G&A improves 1.0%(CSB)0.0%2.0
Research and Development 5,000,0003.8% R&D $500,000($ value)0.0%2.0
Depreciation and Amortization 5,000,0003.8% D&A Stable ($ value)0.0%1.5
Total Operating Costs 50,300,00038.7%0.0%2.5185,000
Operating Income 21,200,00016.3%0.0%2.0
Interest Income 350,0000.3% Approx 3.7% of Avg. Cash 1,460,0001,460,0000.9%
Interest Expense 715,0000.6%8.5% of Total Installment Debt Obligations 0.0%3.0
0.0%
Pre Tax Income 20,835,00016.0%0.0%2.5 Orig Shrs 11,000,000
Tax (21%)4,375,3503.4%21%0.0%1.5 Added
Net Income 16,459,65012.7%0.0%2.0 Proceeds
Bought from Mkt
EPS - Basic $1.502.5 Net shares
EPS - Diluted $1.4415.0
Shares Outstanding 11,000,00011,000,00011,000,000
Shares Outstanding for Diluted 15.0
5 mil common stock warrants exercisable @ $4.60. Stock price for calculations = $5.0057.0 CASH FLOW STATEMENT
Projected
BALANCE SHEET 2023E
12/31/2212/31/23E Net Income 2.0
Cash 5,000,0003.5 Depreciation 1.0
A/R (Avg Collec Period =30 days)10,684,932 Collec period =30 days 3.0
Inventory (Days Inv. Held =45)7,212,329 Days Inv =40 days 3.0 A/R 2.5
Other 5,000,000 $1,000,0002.0 Inventory 2.5
Total Current Assets 27,897,2602.0 Other 2.0
A/P 2.0
PP&E (see note below)50,000,000 No change 2.0 Accrued Liabs 2.0
Less Accumulated Depreciation 5,000,000 PP&E 10 yr SLD 2.0 Total Cash flow from Ops 2.5
Net PP&E 45,000,0001.0
PP&E 2.0
Other 5,000,000 No change 2.0 Other
Total Assets 77,897,2603.0 Financing 2.0
Accounts Payable 10,000,00010%($ value)2.0 Net Cash Flow 2.5
Current portion of LTD 2,000,000 No change 1.523.0
Accrued Liabilities 1,386,000 No change 1.5
Total Current Liabilities 13,386,0002.0125.0
LTD 9,000,000 $1 Mil paid off on 1/1/232.0
Total Liabilities 22,386,0002.5
Common Stock 1,000 No change 1.5
Addl PIC 9,999,000 No change 1.5
Retained Earnings 45,511,2602.5
Shareholder's Equity 55,511,2602.5 B =80 and up
Total Equity and Liabilities 77,897,2602.0
45.0
Average collection Period = Accounts Receiable -: Average Daily Sales -
Average Daily Sales = Sales -: 365-
Days Inventory Held = Inventory -: Average Daily Cost of Sales

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 Creating Value In A Dynamic Business Environment

Authors: Ronald Hilton, David Platt

13th Edition

1264100698, 9781264100699

More Books

Students also viewed these Accounting questions