Complete the spreadsheet. Please complete all 3 sheets.

Download all attachments.

Statements ASSETS Cash & Equivalents Trade Receivables - (net) Inventory All Other Current Total Current Fixed Assets (net) Intangibles (net) All Other Non-Current Total LIABILITIES Notes Payable-Short Term Cur. Mat.-L/T/D Trade Payables Income Taxes Payable All Other Current Total Current Long Term Debt Deferred Taxes All Other Non-Current Net Worth Total Liabilities & Net Worth INCOME DATA Net Sales Gross Profit Operating Expenses Operating Profit All Other Expenses (net) Profit Before Taxes RATIOS Current Quick Sales/Receivables Cost of Sales/Inventory 2335 Women's Junior's dresses 15.7 28.6 37.5 5.7 87.5 5.0 .7 6.9 100.0 13.3 1.1 19.9 .2 11.5 46.0 5.0 .0 2.8 46.5 100.0 100.0 38.1 31.0 7.1 .2 6.9 2.7 1.9 1.3 1.2 1.0 .6 18.8 8.6 6.3 8.4 5.7 2.2 13.0 Cost of Sales/Payables % Profit Before Taxes/Tangible Net Worth 8.6 7.8 3.7 7.0 15.3 7.7 2.4 -.0 .0 .1 .2 .6 1.1 2.5 60.9 24.1 5.5 % Profit Before Taxes/Total Assets 23.6 12.9 .3 Sales/Working Capital EBIT/Interest Fixed/Worth Debt/Worth Sales/Net Fixed Assets Sales/Total Assets % Depr., Dep., Amort./Sales 231.2 99.4 22.7 3.8 2.8 2.0 .1 .3 .6 COMPANY NAME: REMEMBER BALANCE SHEET MUST BALANC Balance Sheet Income Statement Assets: Cash Marketable Securities Account Receivable Inventory Other Current Assets Total Current Assets Sales Less Discounts Cost of Good Sold Gross Profit Plant and Equipment Accumalated Depreciation Net Fixed Assets Other Assets Total Assets Liabilites: Account Payable - Trade Credit Taxes payable Notes Payable Other current liabilities Total Current Liabilities Long term Debt Total Liabilities Stockholder's Equity Common Stock Number of shares authorized Number of shares outstanding par value of common stock Retained Earning Total Stockholders Equity Total Liabilities and Equity Operating Expenses: Depreciation Expenses Administrative Expenses Marketing Exp Salary Ex Total operating Expenses: Earinng before Interest and tax Interest Expenses Earning Before tax Taxes Net Income Tax rate Par Value of Stock Current Stock Price Interest cost- 2.5 over Prime Dividend- Pay out 20% Dividend- Per shares Growth rate Analytical Income Statement Sales Variable cost Contribution Margin Fixed Cost EBIT Cost of capital Cost of Debt Cost Of Retained Earning Cost of New Stock Flotation Costs Dollar Costs CE SHEET MUST BALANCE - RATIOS ARE WITHIN INDUSTRY STANDARDS Ratios Liquidity Quick Current inventory Turn Average collection Period Leverage Debt to Worth Time Int earning DOL % 0f leverage DFL DCL Profitability ROA ROE Marketability Price earning ratio Annual Cash Budget WORKSHEET Sales Cash Collections: Cash Next year Total Cash Receipts Cash Disbursements: Cost of InventoryPurchases Paid Next Year Administrative Marketing Salaries and overhead Interest expense Total disbursments: Net monthly change Before Tax Cash flow Depreciation Taxes After Tax Cash Flow Initial Outlay Cost of Equipment Modification to equipment Installation and Shipping Cost of Training Total Outlay depreciable outlay Growth rate Current year % Growth in sales should reflect the growth by adding $1.1 million in new Year 1 Year 2 Year 3 h by adding $1.1 million in new capital - (how much bigger does this make your company) Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 NPV FOR EQUIPMENT INITIAL OUTLAY AFTER TAX CASH FLOW YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 YEAR 6 YEAR 7 YEAR 8 YEAR 9 YEAR 10 DISCOUNT RATE: NPV FOR EQUIPMENT IRR FOR EQUIPMENT INITIAL OUTLAY IRR FOR EQUIPMENT Profitability index PV of Cash Flows Initial Outlay Profitability index COST OF CAPITAL FINANCE BY DEBT INTERNAL EQUITY EXTERNAL EQUITY COST WEIGHTED COST-TOTAL make sure the percentage you use of each type of capital ma WEIGHTED COSTS 0.0000% use of each type of capital makes sense - meaning that your ratios don't get out of industry standards COMPANY NAME: Gossypium International Balance Sheet Assets: Cash Marketable Securities Account Receivable Inventory Other Current Assets Total Current Assets $ $ $ $ $ $ 521,240.00 200,960.00 1,582,560.00 2,241,960.00 163,280.00 4,710,000.00 8.30% 3.20% 25.20% 35.70% 2.60% 75.00% $ $ $ $ 3,750,000.00 2,651,000.00 1,099,000.00 471,000.00 $6,280,000.00 59.71% 21.43% 17.5% 7.50% 106.14% 841,520.00 12,560.00 1,004,800.00 565,200.00 2,424,080.00 1,055,040.00 3,479,120.00 2,380,000.00 10,000,000.00 4,760,000.00 0.50 420,880.00 2,800,880.00 13.4% 0.2% 16.00% 9.00% 38.60% 16.800% 55.400% Retained Earning Total Stockholders Equity $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total Liabilities and Equity $ 6,280,000.00 Plant and Equipment Accumalated Depreciation Net Fixed Assets Other Assets Total Assets Liabilites: Account Payable - Trade Credit Taxes payable Notes Payable Other current liabilities Total Current Liabilities Long term Debt Total Liabilities Stockholder's Equity Common Stock Number of shares authorized Number of shares outstanding par value of common stock 37.90% 6.70% 44.60% Cost of capital Cost of Debt Cost Of Retained Earning Cost of New Stock Flotation Costs Dollar Costs $ 3.38% 5.99% 6.01% 7% 0.25 REMEMBER BALANCE SHEET MUST BALANCE - RATIOS ARE WITHIN INDUSTRY STANDARDS Income Statement Sales Less Discounts Cost of Good Sold Gross Profit $ $ $ $ $ Operating Expenses: $ Depreciation Expenses $ Administrative Expenses $ Marketing Exp $ Salary Ex $ Total operating Expenses: $ $ Earinng before Interest and tax $ $ Interest Expenses $ $ Earning Before tax $ $ Taxes $ $ Net Income $ Tax rate Par Value of Stock Current Stock Price Interest cost- 1.5 over Prime Dividend- Pay out 20% Dividend- Per shares Growth rate $ $ $ $ Analytical Income Statement Sales $ Variable cost $ Contribution Margin $ 15,700,000.00 533,800.00 10,738,800.00 4,427,400.00 109,900.00 1,452,250.00 345,400.00 2,158,750.00 4,066,300.00 4,066,300.00 361,100.00 92,692.80 268,407.20 67,101.80 201,305.40 25% 0.50 3.50 4.50% 40,261.08 0.0085 5.75% 15,166,200.00 12,141,987.50 3,024,212.50 Ratios Liquidity 100% Quick 3.40% Current 68.40% inventory Turn 28.20% Average collection Period Leverage 0.70% Debt to Worth 9.25% Time Int earning 2.20% DOL % 0f leverage 14% DFL 25.90% DCL 25.90% 2.30% Profitability ROA 0.59% ROE 1.71% Marketability Price earning ratio 0.43% 1.28% Fixed Cost EBIT $ $ 2,663,112.50 361,100.00 NDUSTRY STANDARDS $ 1.02 1.94 4.79 36.79 1.24 3.90 8.375 $ 0.000000245 $ 0.00 3.21% 7.19% 82.76 Annual Cash Budget Current year WORKSHEET Sales Cash Collections: Cash Next year Total Cash Receipts Growth in sales should reflect the growth by adding $1.1 mi Year 1 Year 2 % $ 15,166,200.00 100% $ 16,038,222.50 $ 16,960,384.33 $ 13,583,640.00 89.57% $ 10.43% $ $ 13,583,640.00 $ 14,364,668.84 $ 15,190,605.09 1,582,560.00 $ 1,673,553.65 15,947,228.84 $ 16,864,158.75 $ 10,466,351.41 841,520.00 1,535,751.12 365,259.73 Cash Disbursements: Cost of InventoryPurchases 9,897,280.00 Paid Next Year Administrative $ 1,452,250.00 Marketing $ 345,400.00 Salaries and overhead $ 2,158,750.00 Interest expense $ 92,692.80 Total disbursments: $ 13,946,372.80 Net monthly change Before Tax Cash flow Depreciation Taxes After Tax Cash Flow Installation and Shipping Cost of Training Total Outlay depreciable outlay Growth rate $ $ $ $ 14% $ 1% $ 92% $ $ 11,068,143.15 $ 889,905.51 $ 1,624,053.36 $ 386,261.34 2,282,873.28 $ 98,022.43 $ 47,484,235.65 2,414,133.38 103,658.50 $ (362,732.80) $ (31,537,006.81) $ 16,864,158.75 $ $ $ (362,732.80) 250,000.00 (425,232.80) $ $ $ (31,537,006.81) $ 16,864,158.75 250,000.00 $ 250,000.00 (31,537,006.81) $ 16,864,158.75 $ 62,500.00 $ $ 2,000,000.00 $ 100,000.00 $ $ $ $ 400,000.00 350,000.00 2,850,000.00 2,500,000.00 Initial Outlay calculation Cost of Equipment Modification to equipment 65% 6% 10% 2% 5.75% (7,946,751.70) $ 4,153,539.69 the growth by adding $1.1 million in new capital - (how much bigger does this make your company) Year 3 Year 4 Year 5 Year 6 $ 17,935,568.40 $ 18,966,823.37 $ 20,057,373.19 $ 21,210,627.17 $ 16,064,030.83 $ $ 1,769,779.23 $ $ 17,833,810.06 $ 16,987,676.58 $ 1,871,537.57 $ 18,859,214.15 $ 17,964,429.90 $ 1,979,146.79 $ 19,943,576.68 $ 18,997,344.34 2,092,943.29 21,090,287.63 $ 11,704,536.56 $ $ 941,073.08 $ $ 1,717,432.79 $ $ 408,470.50 $ 12,377,521.17 995,182.68 1,816,181.33 431,956.64 13,089,200.89 1,052,403.45 1,920,607.68 456,793.18 $ $ $ $ $ $ $ 13,841,800.59 $ 1,112,914.29 $ 2,031,038.32 $ 483,057.76 2,552,940.64 $ 109,618.63 $ 2,699,729.00 $ 115,921.45 $ 2,854,957.36 $ 122,586.68 $ 3,019,111.01 129,635.14 $ 17,833,810.06 $ 18,859,214.15 $ 19,943,576.68 $ 21,090,287.63 $ 17,833,810.06 $ $ 250,000.00 $ $ 17,833,810.06 $ 18,859,214.15 $ 250,000.00 $ 18,859,214.15 $ 19,943,576.68 $ 250,000.00 $ 19,943,576.68 $ 21,090,287.63 250,000.00 21,090,287.63 4,652,303.54 $ 4,923,394.17 $ 5,210,071.91 $ 4,395,952.52 $ your company) Year 7 Year 8 Year 9 Year 10 $ 22,430,190.68 $ 23,719,876.35 $ 25,083,716.06 $ 26,525,973.49 $ $ $ 20,089,649.04 $ 2,213,282.84 $ 22,302,931.88 $ 21,244,758.82 $ 2,340,541.64 $ 23,585,300.45 $ 22,466,284.81 $ 2,475,117.53 $ 24,941,402.35 $ 23,758,045.82 2,617,431.24 26,375,477.06 $ $ $ $ 14,637,673.09 1,176,904.36 2,147,818.47 510,832.50 15,479,306.47 1,244,573.73 2,271,313.21 540,204.22 16,369,331.89 1,316,133.93 2,401,908.63 571,264.75 $ $ $ $ $ $ $ $ $ 17,310,531.77 $ 1,391,808.68 $ 2,540,012.99 $ 604,111.20 $ $ 3,192,703.12 $ 137,088.87 $ 3,376,276.40 $ 144,971.17 $ 3,570,404.72 $ 153,306.69 $ 3,775,694.98 162,121.48 $ 22,302,931.88 $ 23,585,300.45 $ 24,941,402.35 $ 26,375,477.06 $ $ $ 22,302,931.88 $ 250,000.00 $ 22,302,931.88 $ 23,585,300.45 $ 250,000.00 $ 23,585,300.45 $ 24,941,402.35 $ 250,000.00 $ 24,941,402.35 $ 26,375,477.06 250,000.00 26,375,477.06 $ 5,513,232.97 $ 5,833,825.11 $ 6,172,850.59 $ 6,531,369.26 NPV FOR EQUIPMENT INITIAL OUTLAY AFTER TAX CASH FLOW YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 YEAR 6 YEAR 7 YEAR 8 YEAR 9 YEAR 10 DISCOUNT RATE: NPV FOR EQUIPMENT COST OF CAPITAL COST $ (2,850,000.00) FINANCE BY DEBT 3.38% $ (7,946,751.70) INTERNAL EQUITY 5.99% $ 4,153,539.69 EXTERNAL EQUITY 6.01% $ 4,395,952.52 $ 4,652,303.54 WEIGHTED COST-TOTAL $ 4,923,394.17 $ 5,210,071.91 $ 5,513,232.97 make sure the percentage you use of each type of capital $ 5,833,825.11 $ 6,172,850.59 $ 6,531,369.26 4.55% $25,469,521.80 IRR FOR EQUIPMENT INITIAL OUTLAY IRR FOR EQUIPMENT $ Profitability index PV of Cash Flows Initial Outlay Profitability index -7.936674315 $24,361,505.61 $ (2,850,000.00) 8.55 (2,850,000.00) 57% WEIGHTED COSTS 55.40% 1.8697500% 10.00% 0.5991439% 34.60% 2.0793315% 100.0000% 4.5482254% use of each type of capital makes sense - meaning that your ratios don't get out of industry standards