Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help me solve this spread sheet Balance Sheet 2018.2021 begin{tabular}{llll} 2018 & 2019 & 2020 & 2021 hline end{tabular} 12. Cash 73 Marketable Securities

Help me solve this spread sheet
image text in transcribed
image text in transcribed
image text in transcribed
Balance Sheet 2018.2021 \begin{tabular}{llll} 2018 & 2019 & 2020 & 2021 \\ \hline \end{tabular} 12. Cash 73 Marketable Securities 14 Accounts Receivable 75 Inventories. Total Current Assets 76 \begin{tabular}{|l|l|l|} \hline 2018 & 2019 & 2020 \\ \hline \end{tabular} 18 Gross Fixed Assets 79 Less: Accumulated Depreciation 80 Net Fixed Assets Intangible Assets Total Assets 83. 84 Notes Payable 85 Accounts Payable 86 Accruals 87. Total Current Liabilities 8988 Long Term Debt. Total Liabilities 91 92 Common Stock N/ Shares QPar $1.00 93 Additional Paid In Capital 94. Retained Earaings 95 Total Liabilities \& Shateholders' Equity 98 100 109101 Jacob Corporation Common-Size Balance Sheet 103 20182021 104 \begin{tabular}{llll} 2018 & 201920202021 \\ \hline \end{tabular} 106 Cash 107 Marketable Securities 103 Accounts Recolvable 109 Imventories 130 Total Current Assets 111 Gross Fixed Assets 112 Gross Fixed Assets 113 Less: Accumulated Depreciation Net Fixed Assets 115 Intangible Assets Total Assots 117 Notes Payable 9 Accounts Payoble 0 Accruals Total Current tiabilities 3 Long Term Debt Total Liahilities Common Stock if Shares efPor $1.00 127 Additional Paid in Copital 126 Rotained Earnings 125 Rotained Earnings Total Liabillities 8 Sharebolden' Equily Income Statement Spreadsheet Example Module I Name: Date: Jacob Corporation Income Statement 2018.2021 Sales \begin{tabular}{|l|l|} 2018 & 2019 \\ \hline \end{tabular} 2020 2021 3 Cost Or Goods Sold Gross Profit Selling \& Administrative Expenses Depreciation 18 Other Operating Expenses 19 Total Operating Expenses 21 Eamings Before Interest 8 Taxes(EBIT) 22 Interest Expense 23 Eamings Before Taxes(EBT) 24 Taxesg40\% Net Income 27 Common Dividends 28 Addition to Retained Earnings 30 Common Shares Outstanding 31 Earnings Per Share(EPS) 32 Dividends Per Share \begin{tabular}{|l|l|} \hline \begin{tabular}{l|l} 33 \\ 34 \end{tabular} & \\ \hline 35 & \\ \hline 36 & \\ \hline 37 & \\ 38 & \\ 39 & \\ 40 & Sales \\ 41 & Cost Of Goods Sold \\ \hline \end{tabular} 42. Gross Prolit 44 Selling 8 Administrative Expenses 45 Depreciation 46 Other Operating Expenses 47 Total Operating Expenses 49 Earnings Before Interest \& Taxes(EBI) 49 Earnings Before 50 Interest Expease Earnings Before Taxes(EBT) Jacob Corporation Common-Size Income Staternent 20182021 52 Taxes(840\% 5. Not income 54 Common Dividends Addition to Retained Earnings(NET) \begin{tabular}{llll} 2018 & 201920202021 \\ \hline \end{tabular} 2018

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

4 How can you create a better online image for yourself?

Answered: 1 week ago