Read the requirements for the project in the .doc file attached below.

Open the .doc file to use the RMA numbers needed for the Excel file.

Complete the spreadsheet in the Blank Excel file.Please complete all 3 sheets. (A sampleExcel file is attached so that you can see the same calculations)

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: 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 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 PROJECT EIGHT INTERNAL RATE OF RETURN YOU ARE THE VICE PRESIDENT OF OPERATIONS OF A CLOTHING MANUFACTURER. YOUR OPERATIONS HAVE BEEN DECLINING IN PRODUCTIVITY AND YOU WANT TO BUY TWO VERY EXPENSIVE PIECES OF EQUIPMENT ($1,000,000 EACH) TO SPEED UP MANUFACTURING- YOU WILL ALSO NEED TO RETRAIN EMPLOYEES. USING THE RMA INDUSTRY RATIOS FOR THIS INDUSTRY (female clothing) YOU NEED TO MAKE UP THE FINANCIAL STATEMENTS OF THIS COMPANY AND GIVE IT A NAME AND IDENTIFY FINANCIAL RATIOS (make sure your balance sheet balances and that your depreciation expense on your income statement and accumulated depreciation on the balance sheet make sense!) LIQUIDITY RATIOS- QUICK, CURRENT, INVENTORY TURN, AVG COLLECTION PERIOD LEVERAGE RATIOS- DEBT TO WORTH, TIMES INTEREST EARNED, DEGREE OF OPERATING LEVERAGE, DEGREE OF FINANCIAL LEVERAGE AND DEGREE OF COMBINED LEVERAGE PROFITABILITY RATIOS - ROA AND ROE MARKETABILITY RATIO- PRICE EARNINGS RATIO 1. YOU NEED TO PUT TOGETHER A PRO FORMA CASH BUDGET THAT PROJECTS THE CHANGES IN CASH THAT WILL BE GENERATED FROM THE TWO NEW MACHINES(12 POINTS) 2. THEN FIGURE THE INTERNAL RATE OF RETURN OF THIS PROJECT AND THE NET PRESENT VALUE (5 POINTS) 3. THEN FIGURE THE COMPANIES COST OF CAPITAL FROM YOUR FINANCIAL STATEMENTS. HOW WILL YOU RAISE THE CAPITAL(DEBT/EQUITY/MIX) (5 POINTS) THE COMPANY CAN NOT BE OVER $10 MILLION IN ASSETS AND ALL NUMBERS. THEY NEED TO MAKE SENSE - WHAT SIZE COMPANY(TOTAL SALES) WOULD BE ABLE TO RAISE $2,000,000 IN CAPITAL. THE ENTIRE FINANCIAL ANALYSIS MUST BE DONE ON A SPREADSHEET PACKAGE (Excel is preferred)