Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please review the financial statement of this company, as attached, and explain in detail what the financial performance of the company was during the past

Please review the financial statement of this company, as attached, and explain in detail what the financial performance of the company was during the past year. Thanks.

image text in transcribedimage text in transcribed

image text in transcribed

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 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

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_2

Step: 3

blur-text-image_3

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

College Accounting Chapters 1-13

Authors: John Price, M. David Haddock, Michael Farina

15th Edition

125999516X, 9781259995163

More Books

Students also viewed these Accounting questions

Question

1. Send the student on an errand, or ask him or her for help.

Answered: 1 week ago