Question: Only question marks and gaps in the last part will be filled. This is all the information. 2020 2021 2020 2021 Cash 1800 N/P 2700

 Only question marks and gaps in the last part will befilled. This is all the information. 2020 2021 2020 2021 Cash 1800N/P 2700 Marketable securities 2600 A/P 1800 A/R 2200 Accrued Expenses 1600

Only question marks and gaps in the last part will be filled. This is all the information.

2020 2021 2020 2021 Cash 1800 N/P 2700 Marketable securities 2600 A/P 1800 A/R 2200 Accrued Expenses 1600 Inventory 4000 Unearned Revenue 1200 1900 7300 Prepaid Expenses Total Current Asset Total Short Term Liabilities Long Term Liabilities 12500 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 4000 Paid in Capital Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 32700 Total Liab & Shr Equ. 32700 | 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 Opex fixed 800 800 CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 45 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 5 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 04 WE WILL MAKE 10000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 72 DAYS (360 DAYS A YEAR) REST OF THE SHORT TERM LIABILITIES WILL CHANGE WITH RESPECT TO SALES NO NEW PREFERRED OR COMMON STOCK ISSUANCE DIVIDEND DISTRIBUTION RATIO TO COMMON STOCKHOLDERS WILL BE 30% OpEx variable 6000 10000 Depreciation 3680 4680 EBIT 11520 12520 Interest all fixed 6900 6900 EBT 4620 5620 Tax (9620) 924 1124 Determine the values in 2021 Proforma balance sheet. All numbers with no commas or full stop Net Income 3696 4496 2000 2000 Preferred Stock Dividend Earning available to 1696 2496 Common Stockholder Marketable securities = ? A/R = ? Inventory = ? Prepaid Expenses = ? Total Current Asset = ? Gross Fixed Asset = ? Accumulated Depreciation = ? Net Fixed Asset = ? Total Assets = ? N/P = ? A/P = ? Accrued Expenses = ? Unearned Revenue = ? Total Short Term Liabilities = Blank Long Term Liabilities = Blank Preferred Stock = Blank Common Stock = Blank Paid in Capital = Blank Retained Earnings = Blank Total Shareholders Equity = Blank Total Liab & Shr Equ. = Blank External Financing Required = 2020 2021 2020 2021 Cash 1800 N/P 2700 Marketable securities 2600 A/P 1800 A/R 2200 Accrued Expenses 1600 Inventory 4000 Unearned Revenue 1200 1900 7300 Prepaid Expenses Total Current Asset Total Short Term Liabilities Long Term Liabilities 12500 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 4000 Paid in Capital Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 32700 Total Liab & Shr Equ. 32700 | 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 Opex fixed 800 800 CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 45 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 5 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 04 WE WILL MAKE 10000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 72 DAYS (360 DAYS A YEAR) REST OF THE SHORT TERM LIABILITIES WILL CHANGE WITH RESPECT TO SALES NO NEW PREFERRED OR COMMON STOCK ISSUANCE DIVIDEND DISTRIBUTION RATIO TO COMMON STOCKHOLDERS WILL BE 30% OpEx variable 6000 10000 Depreciation 3680 4680 EBIT 11520 12520 Interest all fixed 6900 6900 EBT 4620 5620 Tax (9620) 924 1124 Determine the values in 2021 Proforma balance sheet. All numbers with no commas or full stop Net Income 3696 4496 2000 2000 Preferred Stock Dividend Earning available to 1696 2496 Common Stockholder Marketable securities = ? A/R = ? Inventory = ? Prepaid Expenses = ? Total Current Asset = ? Gross Fixed Asset = ? Accumulated Depreciation = ? Net Fixed Asset = ? Total Assets = ? N/P = ? A/P = ? Accrued Expenses = ? Unearned Revenue = ? Total Short Term Liabilities = Blank Long Term Liabilities = Blank Preferred Stock = Blank Common Stock = Blank Paid in Capital = Blank Retained Earnings = Blank Total Shareholders Equity = Blank Total Liab & Shr Equ. = Blank External Financing Required =

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!