Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started