ppt

profileAnger HU
BalancedScorecard-Q8copy.xlsx
Home>Business & Finance homework help>Economics homework help>ppt

Industry Results for Quarter 8

Industry Results for Quarter 8
Indicator Minimum Maximum Average Pineapple.lnc
Total Performance 0.000 4,508.500 1,159.502 129.347
Financial Performance 10.385 461.883 157.679 146.510
Market Performance 0.050 0.470 0.214 0.189
Marketing Effectiveness 0.730 0.838 0.772 0.770
Investment in Future 2.430 4.172 2.939 2.636
Wealth -0.262 3.468 1.144 1.154
Human Resource Management 0.830 0.999 0.930 0.961
Asset Management 1.393 3.371 2.519 3.029
Manufacturing Productivity 0.435 0.874 0.659 0.777
Financial Risk 0.000 1.000 0.658 0.881
End of Worksheet

Cumulative Sheet

Cumulative Results for Quarter 8 Column2 Column3 Column4 Column5
Indicator Minimum Maximum Average Pineapple.lnc
Cumulative Total Performance 0 1,248 320 34
Cumulative Financial Performance 11 223 82 77
Cumulative Market Performance 0 0 0 0
Cumulative Marketing Effectiveness 1 1 1 1
Cumulative Investment in Future 2 4 3 3
Cumulative Wealth -0 3 1 1
Cumulative Human Resource Management 1 1 1 1
Cumulative Asset Management 1 3 2 2
Cumulative Manufacturing Productivity 0 1 1 1
Cumulative Financial Risk 0 1 1 1
End of Worksheet

Cash Flow

Cash Flow Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9
Report Item Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 5 Quarter 6 Quarter 7 Quarter 8
Beginning Cash Balance 0 912,000 723,003 216 959,706 1,195,063 2,885,238 3,031,339
Receipts and Disbursements from Operating Activities
Revenues 0 0 1,050,846 2,643,185 4,711,450 13,196,597 21,923,004 42,106,223
- Rebates 0 0 30,320 74,560 132,800 308,000 496,300 979,560
- Production 0 0 1,002,612 1,110,821 2,704,429 6,115,855 10,471,770 22,381,857
- Research and Development 0 60,000 100,000 260,000 2,509,798 640,000 5,008,111 640,000
- Quality Costs 0 0 27,936 229,237 240,286 436,641 509,701 689,441
- Advertising 0 0 133,400 286,276 598,574 765,504 1,044,108 1,742,950
- Sales Force Expense 0 0 189,832 230,586 525,803 1,143,304 1,899,412 4,991,669
- Sales Office and Web Sales Center Expenses 0 450,000 440,000 344,000 614,818 830,742 1,408,537 1,137,015
- Web Marketing Expenses 0 0 96,000 0 712,090 362,890 1,046,290 2,461,297
- Marketing Research 88,000 0 115,000 115,000 115,000 115,000 115,000 115,000
- Shipping 0 0 14,678 32,901 50,422 169,141 314,159 590,512
- Inventory Holding Cost 0 0 38,605 314 33,765 19,345 33,264 31,454
- Excess Capacity Cost 0 0 65,450 0 138,308 0 0 0
- Income Taxes 0 0 0 0 0 0 0 923,671
+ Interest Income 0 1,203 0 0 0 0 2,250 4,500
- Interest Charges 0 0 0 0 0 0 82,500 82,500
+ Licensing Income 0 0 0 0 0 0 0 0
- Licensing Fees 0 0 0 0 0 0 0 0
+ Other Income 0 0 0 0 0 0 0 0
- Other Expenses 0 0 0 0 0 0 0 0
= Net Operating Cash Flow -88,000 -508,797 -1,202,987 -40,510 -3,664,643 2,290,175 -503,899 5,343,797
Investing Activities
Fixed Production Capacity 0 600,000 600,000 0 1,100,000 600,000 2,200,000 0
+ Sinking Fund 0 0 0 0 0 0 150,000 150,000
= Total Investing Activities 0 600,000 600,000 0 1,100,000 600,000 2,350,000 150,000
Financing Activities
Increase in Common Stock 1,000,000 1,000,000 1,000,000 1,000,000 5,000,000 0 0 0
+ Borrow Conventional Loan 0 0 0 0 0 0 0 0
- Repay Conventional Loan 0 0 0 0 0 0 0 0
+ Borrow Long-Term Loan 0 0 0 0 0 0 3,000,000 0
+ Borrow Emergency Loan 0 0 0 0 0 0 0 0
- Repay Emergency Loan 0 0 0 0 0 0 0 0
- Deposit 3 Month Certificate 0 80,200 0 0 0 0 0 0
+ Withdraw 3 Month Certificate 0 0 80,200 0 0 0 0 0
- Dividends 0 0 0 0 0 0 0 0
- Deposit to Foreign Currencies 0 0 0 0 0 0 0 0
+ Withdraw from Foreign Currencies 0 0 0 0 0 0 0 0
= Total Financing Activities 1,000,000 919,800 1,080,200 1,000,000 5,000,000 0 3,000,000 0
Cash Balance, End of Period 912,000 723,003 216 959,706 1,195,063 2,885,238 3,031,339 8,225,136
End of Worksheet

Income Statement

Income Statement Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9
Report Item Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 5 Quarter 6 Quarter 7 Quarter 8
Gross Profit
Revenues 0 0 1,050,846 2,643,185 4,711,450 13,196,597 21,923,004 42,106,223
- Rebates 0 0 30,320 74,560 132,800 308,000 496,300 979,560
- Cost of Goods Sold 0 0 616,562 1,493,732 2,369,914 6,260,055 10,332,580 22,399,963
= Gross Profit 0 0 403,964 1,074,893 2,208,736 6,628,542 11,094,124 18,726,700
Expenses
Research and Development 0 60,000 100,000 260,000 2,509,798 640,000 5,008,111 640,000
+ Quality Costs 0 0 27,936 229,237 240,286 436,641 509,701 689,441
+ Advertising 0 0 133,400 286,276 598,574 765,504 1,044,108 1,742,950
+ Sales Force Expense 0 0 189,832 230,586 525,803 1,143,304 1,899,412 4,991,669
+ Sales Office and Web Sales Center Expenses 0 450,000 440,000 344,000 614,818 830,742 1,408,537 1,137,015
+ Web Marketing Expenses 0 0 96,000 0 712,090 362,890 1,046,290 2,461,297
+ Marketing Research 88,000 0 115,000 115,000 115,000 115,000 115,000 115,000
+ Shipping 0 0 14,678 32,901 50,422 169,141 314,159 590,512
+ Inventory Holding Cost 0 0 38,605 314 33,765 19,345 33,264 31,454
+ Excess Capacity Cost 0 0 65,450 0 138,308 0 0 0
+ Depreciation 0 0 25,000 50,000 50,000 95,833 120,833 212,500
= Total Expenses 88,000 510,000 1,245,901 1,548,314 5,588,864 4,578,401 11,499,416 12,611,838
Operating Profit -88,000 -510,000 -841,937 -473,422 -3,380,128 2,050,141 -405,292 6,114,862
Miscellaneous Income and Expenses
+ Licensing Income 0 0 0 0 0 0 0 0
- Licensing Fees 0 0 0 0 0 0 0 0
+ Other Income 0 0 0 0 0 0 0 0
- Other Expenses 0 0 0 0 0 0 0 0
+ Foreign Currency Gains and Losses 0 0 0 0 0 0 0 0
= Earnings Before Interest and Taxes -88,000 -510,000 -841,937 -473,422 -3,380,128 2,050,141 -405,292 6,114,862
+ Interest Income 0 1,203 0 0 0 0 2,250 4,500
- Interest Charges 0 0 0 0 0 0 82,500 82,500
= Income Before Taxes -88,000 -508,797 -841,937 -473,422 -3,380,128 2,050,141 -485,542 6,036,862
- Loss Carry Forward 0 0 0 0 0 2,050,141 0 3,727,684
= Taxable Income 0 0 0 0 0 0 0 2,309,178
- Income Taxes 0 0 0 0 0 0 0 923,671
= Net Income -88,000 -508,797 -841,937 -473,422 -3,380,128 2,050,141 -485,542 5,113,191
Earnings per Share -9 -25 -28 -12 -38 23 -5 57
End of Worksheet

Balance Sheet

Balance Sheet Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9
Report Item Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 5 Quarter 6 Quarter 7 Quarter 8
Current Assets
Cash 912,000 723,003 216 959,706 1,195,063 2,885,238 3,031,339 8,225,136
+ 3 Month Certificate of Deposit 0 80,200 0 0 0 0 0 0
+ Foreign Currency Balances 0 0 0 0 0 0 0 0
+ Finished Goods Inventory 0 0 386,050 3,138 337,654 193,454 332,644 314,537
Long Term Assets
+ Sinking Fund 0 0 0 0 0 0 150,000 300,000
+ Net Fixed Assets 0 600,000 1,175,000 1,125,000 2,175,000 2,679,167 4,758,333 4,545,833
= Total 912,000 1,403,203 1,561,266 2,087,844 3,707,717 5,757,858 8,272,316 13,385,507
Debt
Conventional Bank Loan 0 0 0 0 0 0 0 0
+ Long-Term Loan 0 0 0 0 0 0 3,000,000 3,000,000
+ Emergency Loan 0 0 0 0 0 0 0 0
Equity
+ Common Stock 1,000,000 2,000,000 3,000,000 4,000,000 9,000,000 9,000,000 9,000,000 9,000,000
+ Retained Earnings -88,000 -596,797 -1,438,734 -1,912,156 -5,292,283 -3,242,142 -3,727,684 1,385,507
= Total 912,000 1,403,203 1,561,266 2,087,844 3,707,717 5,757,858 8,272,316 13,385,507
End of Worksheet

Financial Ratios

Industry Financial Ratios Column2 Column3 Column4 Column5
Ratio Lowest Highest Average Pineapple.lnc
Liquidity Ratios
Current Liquidity Ratio 1 1 1 N/A
Quick Liquidity Test Ratio 1 1 1 N/A
Activity Ratios
Inventory Turnover 5 71 28 71
Fixed Assets Turnover 3 10 7 9
Total Assets Turnover 2 4 3 3
Leverage Ratios
Debt Ratio 0 129 49 22
Debt to Paid In Capital 0 77 35 29
Profitability Ratios
Gross Profit Margin 27 51 40 44
Net Profit Margin -15 18 3 12
Return on Assets -43 66 15 38
Return on Paid In Capital -2 66 38 49
Financial Statement Highlights
Revenues 5,255,714 98,389,200 42,048,456 42,106,223
Gross Profit 1,896,607 50,440,491 19,284,067 18,726,700
Net Income -3,474,619 17,870,690 4,866,046 5,113,191
End of Worksheet