Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me with the following question. Thanks. Based on the Financial Ratios Q3 & Q4 and Financial Statement for the past year of Company

Please help me with the following question. Thanks.

Based on the "Financial Ratios Q3 & Q4" and "Financial Statement for the past year "of Company A, as attached, would you please explain in detail the market performance of "Company A" during the past year.

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribedimage text in transcribed

Pro Forma Balance Sheet Report Item Quarter 2 Quarter 3 Quarter 4 Quarter 1 Current Assets 14,024 934,900 Cash 555,102 +3 Month Certificate of Deposit + Finished Goods Inventory 332,492 0 54,277 182,063 Long Term Assets +Sinking Fund + Net Fixed Assets = Total 0 948,924 Debt 0 1,103,310 1,658,412 0 1,057,339 1,239,402 0 1,011,368 1,398,136 Conventional Bank Loan +Long-Term Loan + Emergency Loan 0 0 626,687 + Common Stock +Retained Earnings = Total Equity 1,000,000 -51,077 948,924 2,000,000 -341,589 1,658,412 3,000,000 -2,387,285 1,239,402 4,000,000 -2,601,864 1,398,136 Pro Forma Income Statement Report Item Quarter 2 Quarter 3 Quarter 4 Quarter 1 Gross Profit Revenues - Rebates - Cost of Goods Sold = Gross Profit 0 0 161,552 400 83,298 77,854 3,409,078 29,975 1,809,410 1,569,693 Expenses 120,000 500,000 7,822 266,459 151,252 717,644 170,512 Research and Development + Quality Costs + Advertising + Sales Force Expense + Sales Office and Web Sales Center Expenses + Web Marketing Expenses + Marketing Research +Shipping +Inventory Holding Cost + Excess Capacity Cost + Depreciation = Total Expenses Operating Profit 170,000 60,288 216,896 501,978 585,524 44,000 69,000 50,720 5,428 65,100 ooo 0 46,000 2,828 18,206 367,367 45,971 2,123,550 -2,045,696 65,100 -65,100 Miscellaneous Income and Expenses 0 290,512 -290,512 45,971 1,749,805 -180,112 0 0 0 -290,512 -2,045,696 -180,112 -65,100 14,024 +Licensing Income - Licensing Fees + Other Income - Other Expenses = Earnings Before Interest and Taxes + Interest Income - Interest Charges = Income Before Taxes -Loss Carry Forward = Taxable income - Income Taxes = Net Income Earnings per Share 34,468 -214,580 -51,077 -290,512 -2,045,696 0 0 -290,512 -15 -51,077 -5 -214,580 -2,045,696 -56 5 Quarter 4 Quarter 3 555,102 161,552 400 265,361 500,000 7,822 266,459 151,252 717,644 3,409,078 29,975 1,681,624 170,000 60,288 216,896 501,978 585,524 44,000 69,000 50,720 5,428 0 46,000 2,828 18,206 367,367 0 o 0 34,468 0 Pro Forma Cash Flow Report Item Quarter 1 Quarter 2 Beginning Cash Balance 14,024 Receipts and Disbursements from Operating Activities Revenues - Rebates 0 - Production - Research and Development 120,000 - Quality Costs - Advertising - Sales Force Expense - Sales Office and Web Sales Center Expenses 170,512 - Web Marketing Expenses - Marketing Research 65,100 - Shipping - Inventory Holding Cost 0 - Excess Capacity Cost - Income Taxes +Interest Income 14,024 - Interest Charges +Licensing Income - Licensing Fees + Other Income - Other Expenses = Net Operating Cash Flow -51,077 -290,512 Investing Activities Fixed Production Capacity 0 1,103,310 +Sinking Fund 0 = Total Investing Activities 0 1,103,310 Financing Activities Increase in Common Stock 1,000,000 1,000,000 + Borrow Conventional Loan - Repay Conventional Loan + Borrow Long-Term Loan + Borrow Emergency Loan - Repay Emergency Loan - Deposit 3 Month Certificate 934,900 + Withdraw 3 Month Certificate 934,900 - Dividends = Total Financing Activities 65,100 1,934,900 Cash Balance, End of Period 14,024 555,102 Cost of Goods Sold Starting Inventory + Production = Available Inventory - Cost of Goods Sold = Ending Inventory 0 0 0 -40,822 -2,181,787 1,000,000 1,000,000 0 626,687 626,687 0 0 0 0 1,626,687 373,313 332,492 0 0 265,361 265,361 83,298 182,063 182,063 1,681,624 1,863,687 1,809,410 54,277 Industry Financial Ratios Q3 Ratio Lowest Highest Average Company A LIQUIDITY RATIOS Current Liquidity Ratio ? Quick Liquidity Test Ratio ? N/A N/A N/A N/A N/A N/A N/A N/A 5.10 ACTIVITY RATIOS Inventory Turnover? Fixed Assets Turnover ? Total Assets Turnover? 0.42 0.15 0.13 1.24 2.47 0.63 0.47 0.46 0.15 0.13 0.96 LEVERAGE RATIOS Debt Ratio ? Debt to Paid In Capital? 0.00 0.00 50.56 102.28 17.98 32.35 50.56 102.28 PROFITABILITY RATIOS Gross Profit Margin? Net Profit Margin Return on Assets Return on Paid In Capital? 37.61 -1,266.28 - 165.06 -333.87 48.19 -61.72 -59.37 -59.37 4 2.06 -538.48 .99.70 -149.35 48.19 -1,266.28 - 165.06 -333.87 FINANCIAL STATEMENT HIGHLIGHTS Revenues Gross Profit Net Income 161,552 1,306,404 661,879 77,854 494,463 257,458 -2,045,696 -806,269 -1,316,471 161,552 77,854 -2,045,696 Q4 Industry Financial Ratios Company A Ratio Lowest Highest Average LIQUIDITY RATIOS Current Liquidity Ratio Quick Liquidity Test Ratio ? N/A N/A N/A N/A N/A N/A N/A N/A ACTIVITY RATIOS Inventory Turnover Fixed Assets Turnover Total Assets Turnover 35.64 1.97 1.45 162.09 4.18 2.68 83.72 3.11 1.99 35.64 3.15 2.68 LEVERAGE RATIOS Debt Ratio Debt to Paid In Capital 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 42.78 PROFITABILITY RATIOS Gross Profit Margin? Net Profit Margin? Return on Assets Return on Paid In Capital? 35.93 -56.48 -90.84 60.87 9.60 13.97 13.97 44.98 -19.95 -39.10 -39.10 -13.26 -35.47 -35.47 FINANCIAL STATEMENT HIGHLIGHTS Revenues Gross Profit Net Income 1,987,334 4,215,095 3,139,014 714,084 2,565,741 1,480,127 -1,122,418 404,815 440,780 3,184,411 1,362,354 422,283

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

More Books

Students also viewed these Finance questions