Question: By using the following financial data, prepare the sensitivity analysis for financial feasibility for the company and please advice suggestion for long term growth .
By using the following financial data, prepare the sensitivity analysis for financial feasibility for the company and please advice suggestion for long term growth
.



Pro Forma Income Statement Coozy International Co.,Ltd For 2019 through 2023 (all numbers in B000) Y20 B8,443.60 B8,443.60 Y21 B12,828.42 B12,828.42 Y22 B14,752.68 B14,752.68 Y23 B16,965.59 B16,965.59 Y19 REVENUE B7,676.00 B7,676.00 Gross sales Net Sales COST OF SALES Less sales returns and allowances B12,828.42 B7,676.00 B8,443.60 B14,752.68 B16,965.59 B166.25 83.325.00 83,491.25 B100.51 B3,390.75 B1,827.36 B3,527 49 B5,354.85 B47.13 B5, 307 72 B2,929.87 B3,424.75 B6,354.62 B1.827 36 B4,527.26 Beginning inventory Total Goods Available Total Cost of Goods Sold Gross Profit (Loss) OPERATING EXPENSES B100.51 B6,849.50 B6,950.01 B2,929.87 B4,020.13 Plus goods purchased /manufactured B3,325.00 B3,325.00 B166.25 B3,158.75 Less ending inventory B10,225.42 B5,052.86 B8,808.29 B11,657.86 B4,517.25 Selling B441.00 B84.44 B460.00 B30.00 B463.05 B128.28 B460.00 B30.00 Salaries and wages Commissions Advertising Depreciation B420.00 B76.76 B460.00 B30.00 B486.20 B147.53 B460.00 B30.00 B510.51 B169.66 B460.00 B30.00 Other B700 B1,686.76 B600.00 B1,615.44 B600.00 B1,681.33 B600.00 B1,770.17 B1,723.73 Total Selling Expenses Genera Administrative B416.75 B3.00 B20.00 B360.00 B3.00 B55.00 B378.00 B3.00 B20.00 B396.90 B3.00 B20.00 B437.58 Salaries and wages Employee benefits Miscellenous Insurance B20.00 B360.00 B126.00 B360.00 B126.00 B360.00 B126.00 B360.00 B126.00 B360.00 B126.00 en Utilities Depreciation & amortization Office supplies Travel & entertainment Delivery Shipment Equipment maintenance & rental Interest Furniture & equipment B36.00 B36.00 B10.00 B6.00 B36.00 B10.00 B12.00 B36.00 B10.00 B6.00 B36.00 B10.00 B6.00 B6 B400.00 B175.00 B1,521.00 B320.00 B10.00 B1,269.00 B240.00 B10.00 B1,213.90 B160.00 B10.00 B1,147.75 B80.00 B10.00 B1,088.58 Total General/Administrative Expenses B2,895.23 B2,871.47 Total Operating Expenses 83,207 76 B2,884.44 B2,858.75 B1,309.49 B196.42 B1,113.07 B5,913.05 B5,026.10 B0.00 Net Income Before Taxes Net Income After Taxes Extraordinary gain or loss B2,168.42 B325.26 B1,843.16 B7,353.95 B1.470.79 5,883. 16 B8,799.11 B1,759.82 B7,039.29 Taxes on income B0.00 B0.00 B0.00 B0.00 B0.00 Income tax on extraordinary gain B0.00 B0.00 B7.039.29 B1,113.07 B1,843.16 B5,026.10 NET INCOME (LOSS B5,883.16 Coozy International Co.,Ltd For 2019 through 2023 (all numbers in B000) Y20 Y23 Y22 Y19 YO Asset Cash or cash equivalents Account Recievable Inventories Current Assets-others Tangible Fixed Assets Intangible Fixed Assets Total Assets B5,540.00 B5,136.55 B6,443.36 B7,948.75 B13,784.05 B21,127.96 B1,535.20 B1,688.72 B2,565.68 B2,950.54 B3,393.12 B47.13 B166.25 B100.51 B2,929.87 B1,827.36 B460.00 B460.00B460.00 B460.00 B460.00 B460.00 B30.00 B25.00 B0.00 B25.00 B90.00 B25.00 B60.00 B25.00 B120.00 B25.00 B6,000.00 B7,443.00 B8,807.59 B13,989.31 B19,076.94 B25,053.21 Liabilities & Shareholders' Equity Account Payable Loan Liabilities-Others Capital Stock Retained Earnings Total Liabilities & Shareholders Equity B1,329.93 B1,259.36 B2,152.95 B1,300.07 B1,331.29 B0.00 B592.01 B854.05 1,911.40 B2,017.15 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,113.07 B2,956.22 B7,982.32 B13,865.48 B20,704.77 5,000.00 B4,000.00 B3,000.00 B2,000.00 BI,000.00 B6,000.00 B7,443.00 B8,807.59 B13,989.31 B19,076.94 B25,053.20 Coozy International Co.,Ltd For 2019 through 2023 (all numbers in B000) Y19 B153.52 Y21 B256.57 Y22 B295.05 Year YO Y20 B168.87 Y23 B339.31 B5,987.28 B8,121.21 B11,694.89 B14,072.78 B16,183.69 Cash sale Accounts receivable Miscellaneous revenue B1,000.00 Cash in B1,000.00 B6,140.80 B8,290.08 B11,951.46 B14,367.83 B16,523.00 B460.00 B3,935.40 B4,238.08 B6,918.84 B4,360.21 B4,453.86 B951.09 B80.00 Accounts payable Labor cost Interest cost Corporation tax Vat Miscellaneous (Share paid) 3783.00 B400.00 B196.42 B325.26B886.96 B1,470.79 B1,759.82 B229.42 B822.00 B320.00 B862.95 B240.00 B905.95 1 60.00 B277.93 B0.00 B734.31 B537.32 B635.59 B0.00 B200.00 B460.00 B5,544.25 B5,983.27 B9,446.07 B7,532.54 B8,179.09 B596.55 B2,306.81 B2,505.39 B6,835.29 B8,343.91 B0.00 B0.00 Cash out Short-term Long-term B5,000.00 5,000.00 B0.00 B0.00 0.00 Loans in B0.00 B0.00 Short-term(-) Long-term(-) B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 5,540.00 5,136.55 6,443.36 37,948.75 1 3,784.05 21"127.96 Loan out Cash Pro Forma Income Statement Coozy International Co.,Ltd For 2019 through 2023 (all numbers in B000) Y20 B8,443.60 B8,443.60 Y21 B12,828.42 B12,828.42 Y22 B14,752.68 B14,752.68 Y23 B16,965.59 B16,965.59 Y19 REVENUE B7,676.00 B7,676.00 Gross sales Net Sales COST OF SALES Less sales returns and allowances B12,828.42 B7,676.00 B8,443.60 B14,752.68 B16,965.59 B166.25 83.325.00 83,491.25 B100.51 B3,390.75 B1,827.36 B3,527 49 B5,354.85 B47.13 B5, 307 72 B2,929.87 B3,424.75 B6,354.62 B1.827 36 B4,527.26 Beginning inventory Total Goods Available Total Cost of Goods Sold Gross Profit (Loss) OPERATING EXPENSES B100.51 B6,849.50 B6,950.01 B2,929.87 B4,020.13 Plus goods purchased /manufactured B3,325.00 B3,325.00 B166.25 B3,158.75 Less ending inventory B10,225.42 B5,052.86 B8,808.29 B11,657.86 B4,517.25 Selling B441.00 B84.44 B460.00 B30.00 B463.05 B128.28 B460.00 B30.00 Salaries and wages Commissions Advertising Depreciation B420.00 B76.76 B460.00 B30.00 B486.20 B147.53 B460.00 B30.00 B510.51 B169.66 B460.00 B30.00 Other B700 B1,686.76 B600.00 B1,615.44 B600.00 B1,681.33 B600.00 B1,770.17 B1,723.73 Total Selling Expenses Genera Administrative B416.75 B3.00 B20.00 B360.00 B3.00 B55.00 B378.00 B3.00 B20.00 B396.90 B3.00 B20.00 B437.58 Salaries and wages Employee benefits Miscellenous Insurance B20.00 B360.00 B126.00 B360.00 B126.00 B360.00 B126.00 B360.00 B126.00 B360.00 B126.00 en Utilities Depreciation & amortization Office supplies Travel & entertainment Delivery Shipment Equipment maintenance & rental Interest Furniture & equipment B36.00 B36.00 B10.00 B6.00 B36.00 B10.00 B12.00 B36.00 B10.00 B6.00 B36.00 B10.00 B6.00 B6 B400.00 B175.00 B1,521.00 B320.00 B10.00 B1,269.00 B240.00 B10.00 B1,213.90 B160.00 B10.00 B1,147.75 B80.00 B10.00 B1,088.58 Total General/Administrative Expenses B2,895.23 B2,871.47 Total Operating Expenses 83,207 76 B2,884.44 B2,858.75 B1,309.49 B196.42 B1,113.07 B5,913.05 B5,026.10 B0.00 Net Income Before Taxes Net Income After Taxes Extraordinary gain or loss B2,168.42 B325.26 B1,843.16 B7,353.95 B1.470.79 5,883. 16 B8,799.11 B1,759.82 B7,039.29 Taxes on income B0.00 B0.00 B0.00 B0.00 B0.00 Income tax on extraordinary gain B0.00 B0.00 B7.039.29 B1,113.07 B1,843.16 B5,026.10 NET INCOME (LOSS B5,883.16 Coozy International Co.,Ltd For 2019 through 2023 (all numbers in B000) Y20 Y23 Y22 Y19 YO Asset Cash or cash equivalents Account Recievable Inventories Current Assets-others Tangible Fixed Assets Intangible Fixed Assets Total Assets B5,540.00 B5,136.55 B6,443.36 B7,948.75 B13,784.05 B21,127.96 B1,535.20 B1,688.72 B2,565.68 B2,950.54 B3,393.12 B47.13 B166.25 B100.51 B2,929.87 B1,827.36 B460.00 B460.00B460.00 B460.00 B460.00 B460.00 B30.00 B25.00 B0.00 B25.00 B90.00 B25.00 B60.00 B25.00 B120.00 B25.00 B6,000.00 B7,443.00 B8,807.59 B13,989.31 B19,076.94 B25,053.21 Liabilities & Shareholders' Equity Account Payable Loan Liabilities-Others Capital Stock Retained Earnings Total Liabilities & Shareholders Equity B1,329.93 B1,259.36 B2,152.95 B1,300.07 B1,331.29 B0.00 B592.01 B854.05 1,911.40 B2,017.15 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,113.07 B2,956.22 B7,982.32 B13,865.48 B20,704.77 5,000.00 B4,000.00 B3,000.00 B2,000.00 BI,000.00 B6,000.00 B7,443.00 B8,807.59 B13,989.31 B19,076.94 B25,053.20 Coozy International Co.,Ltd For 2019 through 2023 (all numbers in B000) Y19 B153.52 Y21 B256.57 Y22 B295.05 Year YO Y20 B168.87 Y23 B339.31 B5,987.28 B8,121.21 B11,694.89 B14,072.78 B16,183.69 Cash sale Accounts receivable Miscellaneous revenue B1,000.00 Cash in B1,000.00 B6,140.80 B8,290.08 B11,951.46 B14,367.83 B16,523.00 B460.00 B3,935.40 B4,238.08 B6,918.84 B4,360.21 B4,453.86 B951.09 B80.00 Accounts payable Labor cost Interest cost Corporation tax Vat Miscellaneous (Share paid) 3783.00 B400.00 B196.42 B325.26B886.96 B1,470.79 B1,759.82 B229.42 B822.00 B320.00 B862.95 B240.00 B905.95 1 60.00 B277.93 B0.00 B734.31 B537.32 B635.59 B0.00 B200.00 B460.00 B5,544.25 B5,983.27 B9,446.07 B7,532.54 B8,179.09 B596.55 B2,306.81 B2,505.39 B6,835.29 B8,343.91 B0.00 B0.00 Cash out Short-term Long-term B5,000.00 5,000.00 B0.00 B0.00 0.00 Loans in B0.00 B0.00 Short-term(-) Long-term(-) B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 B1,000.00 5,540.00 5,136.55 6,443.36 37,948.75 1 3,784.05 21"127.96 Loan out Cash
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
