2020 2021 2020 2021 Cash 1800 N/P 2700 Marketable securities 2600 A/P 1800 A/R 2200 Accrued...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = 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 Prepaid Expenses Total Short Term Llabilities 1900 7300 Total Current Asset 12500 Long Term Liabilities 12000 Gross Fixed Asset 30800 Preferred Stock 1000 Accumulated Depreciation 10600 Common Stock 2000 Net Fixed Asset 20200 Paid in Capital 4000 Retained Earnings 6400 Total Shareholders Equity 13400 Total Assets 12 70 Total Liab & Shr Equ. 32700 The 2020 income statement and 202 proforma iricome statement are as follows 2019 2020 Revenue 40000 50000 COGS fixed 2000 2000 COGS variable 16000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 10000 6000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 1060 924 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 20000 Gross Profit 22000 28000 OpEx fixed 800 800 OpEx variable 6000 10000 Depreciation 3680 5000 EBIT 11520 12200 Interest all fixed 6900 6900 EBT 4620 5300 Tax (%20) 924 1060 Net Income 3696 4240 Preferred Stock Dividend 2000 2000 Earning available to 1696 2240 Common Stockholder CASH WILL REMAIN THE SAME WE WANT 2021 COLLECTION PERIOD TO BE 72 DAYS (360 DAYS A YEAR) WE WANT 2021 INVENTORY TURNOVER TO BE 4 PREPAID EXPENSE WILL CHANGE WITH RESPECT TO CHANGE IN SALES WE WANT CASH RATIO TO BE 0.2 WE WILL MAKE 12000 TRY FIXED ASSET INVESTMENT WE WANT 2021 PAYMENT PERIOD TO BE 90 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 25% Determine the values in 2021 Proforma balance sheet. All numbers with ino.commas or full stop Cash = 1800 (as an example) Marketable securities A/R = Inventory = !! Prepaid Expenses = %3D 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 = O Ar Accrued Expenses = %3D Unearned Revenue: Total Short Term Liabilities = %3D Long Term Liabilities = Preferred Stock Common Stock= %3D Paid in Capital = Retained Earnings = Total Shareholders Equity %3D Total Liab & Shr Equ. = External Financing Required =
Expert Answer:
Answer rating: 100% (QA)
1 Calculation of Receivables Average collection period 360days Receivable turnover Ratio 60 Days Therefore Receivable Turnover Ratio 6 Receivable Turn... View the full answer
Related Book For
Financial Accounting an introduction to concepts, methods and uses
ISBN: 978-0324789003
13th Edition
Authors: Clyde P. Stickney, Roman L. Weil, Katherine Schipper, Jennifer Francis
Posted Date:
Students also viewed these accounting questions
-
On Dec. 31, 2013, Neyo Co. purchased machinery for $95,933.37. The Co. paid $20,000 down & agreed to finance the remainder by making 4 equal payments each Dec. 31 at the implicit interest rate of...
-
The following income statement and balance sheets for Virtual Gaming Systems are provided. Required: Assuming that all sales were on account, calculate the following risk ratios for 2015. 1....
-
The 2013 income statement and other information for Mallard Corporation, which is about to purchase a new machine at a cost of $500 and a new computer system at a cost of $300, follows. Sales...
-
Calculate the managerial remuneration from the following particulars of Zen Ltd. the company has only one Managing Director. Net Profit Net Profit is calculated after considering the following:...
-
Complete the following chart regarding the indirect method. Add to Net Income Decrease Increase Subtract from Net Income Increase Decrease
-
Show that the Stefan-Maxwell model can be rearranged to define a pseudo-binary diffusivity, \(D_{i \mathrm{~m}}\), for species \(i\) in the mixture: \[\frac{1}{D_{i...
-
The filament-wound E-glass/epoxy pressure vessel described in Example 4.4 is to be used in a hot-wet environment with temperature \(T=100^{\circ} \mathrm{F}\) \(\left(38^{\circ} \mathrm{C} ight)\)...
-
Adams Corporation acquired 90 percent of the outstanding voting shares of Barstow, Inc., on December 31, 2016. Adams paid a total of $603,000 in cash for these shares. The 10 percent non-controlling...
-
Newton's Universal Law of Gravity (NULG) A) Discuss Newton's Universal Law of Gravity (NULG). a. What is required for there to be gravity? b. On what does gravity depend? c. What is the difference,...
-
Capital Toys' management is considering eliminating product A, which has been showing a loss for several years. The company's annual income statement, in $000s, is as follows: a. Specific to each...
-
Find the Inverse Laplace Transform of the following statement. 4e-2p 2-16
-
A \(100-\mathrm{mm}\) section of wire is bent into a circular arc. What must the radius of the arc be for a current of \(6.0 \mathrm{~A}\) to produce a magnetic field of \(7.5 \times 10^{-5}...
-
Consider a conducting wire having a shape of a hexagon carries a current that flows in an anti-clockwise manner when viewed from the above. What is the direction of the magnetic field at the center...
-
Consider two charged particles 1 and 2, each of them able to translate (move from place to place) and to spin. In which of the following circumstances is there a magnetic interaction between the...
-
We have a rotating tank of diameter, \(0.5 \mathrm{~m}\) and height, \(1.5 \mathrm{~m}\). The tank is filled with water at \(300 \mathrm{~K}\) to a depth of \(1 \mathrm{~m}\). a. How fast would we...
-
A circular current loop lies in the \(x y\) plane of an \(x y z\) coordinate system and is initially oriented so that it carries a clockwise current when viewed from the positive \(z\) axis. It is...
-
Bark River Machine and Tool Company Market Price, January 1 $60.00 Dividend, December 31 $2.00 Market Price, December 31 $65.00 Broker Commission, per Share Maintenance Margin Investor Money Invested...
-
Perform the operation by first converting the numerator and denominator to scientific notation. Write the answer in scientific notation. 7,200,00/0.000009
-
Valuation of brand name. When an acquiring firm purchases another firm with established brand names, it will likely allocate a portion of the purchase price to the brand names. Measuring the fair...
-
Journal entries for service contracts. Abson Corporation began business on January 1, 2008, selling copiers. It also sells service contracts to maintain and repair copiers for $600 per year. When a...
-
Journal entries for warranty liabilities and subsequent expenditures. Miele Company is a German family-owned appliance business. Assume that Miele provides a two-year warranty on its products and...
-
Maribel Ortiz is puzzled. Her company had a profit margin of 10% in 2025. She feels that this is an indication that the company is doing well. Gordon Liddy, her accountant, says that more information...
-
At December 31, 2025, the fair value of non-trading securities is 41,300 and the cost is 39,800. At January 1, 2025, there was a credit balance of 900 in the Fair Value Adjustment Non-Trading...
-
On January 1, 2025, Lennon Enterprises acquires 100% of Ono Ltd. for 220,000 in cash. The condensed statements of financial position of the two companies immediately following the acquisition are as...
Study smarter with the SolutionInn App