Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer the following A-L in as much detail as possible: Details below will provide information on the; How to determine Borrowing Needed, Target Ending

Please answer the following A-L in as much detail as possible: Details below will provide information on the; How to determine Borrowing Needed, Target Ending Cash Balance, Financial Identity, Income Statement, Balance Sheet, and Statement of Cash Flows. These documents will help I hope. Thank you for this.

A: Working Capital

B: Current Ratio

C: Quick Ratio

D: Accounts Receivable Turnover

E: Number of days sales in recievables

F: Inventory Turnover

G: Number of Days Sales in Inventory

H: Ratio of Liabilities to Stockholders Equity

I: Asset Turnover

J: Return on Total Assets:

K: Return on Common Stockholders' Equity

L: Price-Earnings Ratio

Appendix: How to determine "Borrowing Needed"
Ending cash without borrowing: (382,692)
Target ending cash: 2 months of administrative salaries and SG&A expenses:
$312,424/12 * 2 = $52,071
Cash needed = Target ending cash -ending cash
= $52,071 - [-$277,940]
= $330,010
Borrowing needs to account for the 6% interest payment.
Let borrowing needed be X, interest rate be 6%, then X - X * 6% = Cash needed,
X * 94% = Cash needed,
X = Cash needed / 94% = $330,010 / 94%
= $351,075
year 1 sales 21,714
year 2 sales 27,571
year 3 sales 33,698
year 4 sales 41,035
year 5 sales 47,749
Material cost 8.9675
Target Ending Cash Balance
SG&A Expenses 160,000
Salaries Wages and Benefits 152,424
Total Administrative Expenses 312,424
Target Ending Cash 52,071
(2 Months of Administrative Expenses)
Current Ending Cash (277,940)
Target Ending Cash 52,071
Cash Needed 330,010
Borrowing Needed (@ 6% interest) 351,075
Interest Expense 21,064
Financial Identity
Year 1 Financial Identity Cash AR Inv NFA AP Accruals LTD CS RE
Beg. Balance $- $- $- $- $- $- $- $- $-
Pay AP
Pay Accruals
Collect AR's
Initial Inventory $(10,000) $10,000
Buy Manufacturing Equipment $(183,000) $183,000
Buy Office Equipment $(85,000) $85,000
Buy Building, Retrofit $(480,000) $480,000
Production: Materials Purch. $90,439 $90,439
Production: Labor $57,574 $57,574
Production: Depreciation $36,600 $(36,600)
Payments for AP's $(82,902) $(82,902)
Payments for Labor $(55,360) $(55,360)
Payments for Credit Card Transactions $(3,707) $3,707
Revenues $368,591 $2,059 $370,650
COGS(Materials) (90,439) $(90,439)
COGS(Labor) (57,574) $(57,574)
COGS (Depreciation) (36,600) $(36,600)
COGS (Credit Card Transaction Cost) $(3,707) $(3,707)
SG&A Expenses $(160,000) $(160,000)
Salaries, Wages and Benefits $(146,562) $5,862 $(152,424)
Lease Expense $- $-
Depreciation Exp. (Building) $(16,000) $(16,000)
Depreciation Exp. (Office Equip.) $(17,000) $(17,000)
Interest $(21,064) $(21,064)
Taxes $-
Dividends $-
Owners Investment $60,000 $60,000
Outside Equity Investment $500,000 $500,000
Borrowing Needed $351,075 $351,075
Ending B/S 52,071 2,059 10,000 678,400 7,537 8,077 351,075 560,000 (184,158)

Income Statement
Year 1 %
Revenues $370,650 100.0%
COGS(Materials) (90,439) -24.4%
COGS(Labor) (57,574) -15.5%
COGS (Depreciation) (36,600) -9.9%
COGS (Credit Card Transaction Costs) (3,707) -1.0%
Gross Margin $182,330 49.2%
SG&A Expenses (160,000) -43.2%
Salaries, Wages and Benefits (152,424) -41.1%
Lease Expense 0 0.0%
Depreciation Exp. (Building) (16,000) -4.3%
Depreciation Exp. (Office Equip.) (17,000) -4.6%
EBIT $(163,094) -44.0%
Interest (21,064) -5.7%
EBT $(184,158) -49.7%
Taxes 0 0.0%
EAT $(184,158) -49.7%
Dividends $-
Change in Retained Earnings $(184,158)
Balance Sheet
Initial Year 1 %
Cash 163,075 52,071 6.2%
Accounts Receivable 0 2,059 0.3%
Inventory 0 10,000 1.4%
Total Current Assets $163,075 $64,131 7.8%
Net Fixed Assets 748,000 678,400 92.2%
Total Assets $911,075 $742,531 100.0%
Accounts Payable 0 7,537 0.0%
Accruals 0 8,077 0.9%
Current Liabilities $- $15,613 0.9%
Long-term Debt 351,075 351,075 42.5%
Common Stock 560,000 560,000 76.1%
Retained Eanings 0 (184,158) -19.5%
Total Liabilities & Equity $911,075 $742,531 100.0%
Statement of Cash Flows
Year 1
Cash flows from operating activities
Cash receipts from customers 368,591
Cash paid to suppliers (92,902)
Cash paid to employees (201,921)
Expenses (SGA, credit card, etc.) (163,707)
Net cash flows from operating activities $(89,940)
Cash flow from investing activities
Capital expenditure (748,000)
Proceeds from the sale of equipment 0
Net cash flows from investing activities $(748,000)
Cash flow from financing
Equity investment 560,000
Increase (decrease) in debt 351,075
Dividends paid 0
Interest paid (21,064)
Net cash flows from investing activities $890,011
Net cash flow $52,071

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

Management Research Methods

Authors: Phyllis Tharenou, Ross Donohue, Brian Cooper

1st Edition

0521694280, 9780521694285

More Books

Students also viewed these Accounting questions