Worksheet 1
Income Statement | 2019 | 2018 | 2017 | |||
Sales Revenue | $ 693,470 | $ 534,293 | $ 526,945 | |||
Other Revenue | $ 12,000 | $ 16,854 | $ 24,859 | |||
Total | $ 705,470 | $ 551,147 | $ 551,804 | |||
Cost of Goods Sold | $ 283,877 | $ 231,878 | $ 257,334 | |||
Operating expenses | $ 176,820 | $ 112,968 | $ 103,469 | |||
Interest expenses | $ 12,188 | $ 11,484 | $ 14,280 | |||
Income Tax expenses | $ 74,479 | $ 85,046 | $ 74,687 | |||
Total | $ 547,364 | $ 441,376 | $ 449,770 | |||
Profit/ (Loss) | $ 158,106 | $ 109,771 | $ 102,034 | |||
Balance Sheet' | ||||||
Assets | ||||||
Cash | $ 66,650 | $ 49,865 | $ 22,553 | |||
Accounts receviable | $ 89,627 | $ 120,313 | $ 89,515 | |||
Inventory | $ 94,071 | $ 71,097 | $ 55,116 | |||
Prepaid expenses | $ 12,430 | $ 18,200 | $ 5,060 | |||
Property and Equipment | $ 755,857 | $ 645,120 | $ 594,330 | |||
Total | $ 1,018,635 | $ 904,595 | $ 766,574 | |||
Liabilities | ||||||
Accounts payable | $ 50,464 | $ 85,261 | $ 67,010 | |||
Accrued expenses' | $ 10,600 | $ 12,869 | $ 45,870 | |||
Long term debt | $ 178,000 | $ 185,000 | $ 180,000 | |||
Common stock | $ 6,000 | $ 6,000 | $ 5,000 | |||
Additional paid in capital | $ 99,000 | $ 99,000 | $ 62,000 | |||
retained earnings | $ 516,465 | $ 406,694 | $ 304,660 | |||
Profit for the year | $ 158,106 | $ 109,771 | $ 102,034 | |||
Total | $ 1,018,635 | $ 904,595 | $ 766,574 |
Worksheet 2
Income statement and balance sheet
2019 | 2018 | 2017 | |
Income | $ 705,470 | $ 551,147 | $ 551,804 |
Expenses | $ 547,364 | $ 441,376 | $ 449,770 |
Profit | $ 158,106 | $ 109,771 | $ 102,034 |
Balance Sheet | |||
Assets' | $ 1,018,635 | $ 904,595 | $ 766,574 |
Liabilities | $ 239,064 | $ 283,130 | $ 292,880 |
Capital | $ 779,571 | $ 621,465 | $ 473,694 |
Vertical trend analysis
Vertical Trend | 2019 | 2018 | 2017 |
Income Statement | |||
Sales Revenue | 100.00% | 100.00% | 100.00% |
Other Revenue | 1.73% | 3.15% | 4.65% |
Total | 101.73% | 103.15% | 103.28% |
Cost of Goods Sold | 40.94% | 43.40% | 48.16% |
Operating expenses | 25.50% | 21.14% | 19.37% |
Interest expenses | 1.76% | 2.15% | 2.67% |
Income Tax expenses | 10.74% | 15.92% | 13.98% |
Total | 78.93% | 63.65% | 82.61% |
Profit/ (Loss) | 22.80% | 15.83% | 20.55% |
Balance Sheet' | |||
Assets | |||
Cash | 6.54% | 5.51% | 2.94% |
Accounts receviable | 8.80% | 13.30% | 11.68% |
Inventory | 9.24% | 7.86% | 7.19% |
Prepaid expenses | 1.22% | 2.01% | 0.66% |
Property and Equipment | 74.20% | 71.32% | 77.53% |
Total | 100.00% | 100.00% | 100.00% |
Liabilities | |||
Accounts payable | 4.95% | 9.43% | 8.74% |
Accrued expenses' | 1.04% | 1.42% | 5.98% |
Long term debt | 17.47% | 20.45% | 23.48% |
Common stock | 0.59% | 0.66% | 0.65% |
Additional paid in capital | 9.72% | 10.94% | 8.09% |
retained earnings | 50.70% | 44.96% | 39.74% |
Profit for the year | 15.52% | 12.13% | 13.31% |
Total | 100.00% | 100.00% | 100.00% |
Horizontal trend analysis
Horizontal Trend | 2019 | 2018 | 2017 |
Income Statement | |||
Sales Revenue | 131.60% | 101.39% | 100.00% |
Other Revenue | 48.27% | 67.80% | 100.00% |
Total | 127.85% | 99.88% | 100.00% |
Cost of Goods Sold | 110.31% | 90.11% | 100.00% |
Operating expenses | 170.89% | 109.18% | 100.00% |
Interest expenses | 85.35% | 80.42% | 100.00% |
Income Tax expenses | 99.72% | 113.87% | 100.00% |
Total | 121.70% | 98.13% | 100.00% |
Profit/ (Loss) | 154.95% | 107.58% | 100.00% |
Balance Sheet' | |||
Assets | |||
Cash | 295.53% | 221.10% | 100.00% |
Accounts receviable | 100.13% | 134.41% | 100.00% |
Inventory | 170.68% | 129.00% | 100.00% |
Prepaid expenses | 245.65% | 359.68% | 100.00% |
Property and Equipment | 127.18% | 108.55% | 100.00% |
Total | 132.88% | 118.00% | 100.00% |
Liabilities | |||
Accounts payable | 75.31% | 127.24% | 100.00% |
Accrued expenses' | 23.11% | 28.06% | 100.00% |
Long term debt | 98.89% | 102.78% | 100.00% |
Common stock | 120.00% | 120.00% | 100.00% |
Additional paid in capital | 159.68% | 159.68% | 100.00% |
retained earnings | 169.52% | 133.49% | 100.00% |
Profit for the year | 154.95% | 107.58% | 100.00% |
Total | 132.88% | 118.00% | 100.00% |
please help me!!! Using the trial balances data on the following page complete the following in...
you should use Excel
formulas
2. Using the trial balances data on the following page complete the following in Excel using two worksheets (Total 345 points): a. For worksheet 1: i. Enter the data as provided (36 pts) ii. Use the SUMO function to check your data entry, (12 pts) iii. Format the columns using appropriate formats ($ signs in first and last numbers in a column; numbers line up, commas for 000's, underlining of numbers only (not entire cell)...
You should use EXCEL
formula
2. Using the trial balances data on the following page complete the following in Excel using two worksheets (Total 345 points): a. For worksheet 1: i. Enter the data as provided (36 pts) ii. Use the SUMO function to check your data entry, (12 pts) iii. Format the columns using appropriate formats ($ signs in first and last numbers in a column; numbers line up, commas for 000's, underlining of numbers only (not entire cell)...
MUST BE DONE ON EXCEL USING
EXCEL FORMULAS
2. Using the trial balances data on the following page complete the following in Excel using two worksheets (Total 345 points): a. For worksheet 1: i. Enter the data as provided (36 pts) ii. Use the SUMO function to check your data entry, (12 pts) iii. Format the columns using appropriate formats ($ signs in first and last numbers in a column; numbers line up, commas for 000's, underlining of numbers only...
I'm stuck on 2b(ii) and 2b(iii). Please do those in Excel and
take screenshots.
2. Using the trial balances data on the following page complete the following in Excel using two worksheets (Total 345 points): a. For worksheet 1: i. Enter the data as provided (36 pts) ii. Use the SUMO function to check your data entry, (12 pts) iii. Format the columns using appropriate formats ($ signs in first and last numbers in a column; numbers line up, commas...
please help me create an income statement. asap
Wap Text cop 2 Normal Paste Merge & Center - Format Panter e $ Conditional Formats Check Cell Foming Table N- Kobelsky CPA Services Ltd Adjusted Trial Balances For the Years Ending 2018 Credit Debit Debit Credit 534,293 16,854 691 40 12.000 526,945 21,377 $ 231,878 112,968 11.484 257,334 101,469 14.280 7 Sales revenue 8 Other revenue 9 Cost of goods sold 10 Operating expenses 11 Interest expense 12 Income Tax Expense...
R THE L ord you 4. Use the Adjusted Trial Balance numbers to complete the Income Statement, Statement of Retained Earnings, and Balance Sheet For purposes of the Income Statement, prepare using the multiple step format and assume that Rent Revenue, any Unrcalized Holding Gains/Losses, Interest Expense, Interest Revenue, and any other Gains/Losses are NOT part of the major central ongoing operations of the company. For purposes of the Balance Sheet, be sure to prepare a classifed Balance Sheet. Link...
ch1 Excel ka ta ki DD File Home Insert Draw Page Layout Formulas Data ReviewView Help Tell me what you want to do 凸Share Commen Conditional Format as Cell Insert Delete Format FormattingTable- Styles Merge & Center iter Select Styles G25 1 Echo Lake Corporation 2 Transaction Analysis INFORMATION Echo Lake Corporation started operations on November 1, 2018. The nine transactions that occurred during November appear below Requirements 1. Use Excel to prepare a transaction analysis of the nine transactions....
please help me with parts 3,4,5
Following is the November 30, 2020 unadjusted trial balance of Zenith Delivery Company, Inc. The account balances represent the results of entries recorded during the first 11 months of 2020. There have been no stock transactions during the year. Zenith Delivery Company, Inc. Unadjusted Trial Balance November 30, 2020 ACCT# DEBITS CREDITS $ 69.660 4.600 730 1.200 6,500 295,000 $ 115,000 1,300 0 0 1.600 128.000 20,000 42.000 Cash Accounts Receivable Office Supplies Prepaid...
please show all work in Excel
CHAPTER 2: THE BASIC FINANCIAL STATEMENTS Homework for Chapter 2: Problem # 1 in the text (Chapter 2) Using the data presented below for Blue Sky Inc.: 2017 2016 S7,550,000 $6,150,000 5,750,000 Sales Cost of Goods Depreciation Selling and G&A Expenses Fixed Expenses Lease Expense Interest Expense 4,550,000 120,000 100,000 820,000 730,000 200,000 200,000 150,000 150,000 350,000 300,000 Tax Rate 40.00% 40.00% Shares Outstanding Cash Marketable Securities Accounts Receivable Inventory Prepaid Expenses Plant &...
Please answer question C.
Problem 4-02A a-e (Part Level Submission) The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. . 130 157 Ayayai Company Worksheet For the Year Ended December 31, 2019 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,000 112 Accounts Receivable 10,500 126 Supplies 1,200 Prepaid Insurance 1,800 Equipment 26,500 158 Accumulated Depreciation-Equipment 5,000 200 Notes Payable 12,000 201 Accounts Payable 5,800 212 Salaries and Wages Payable 2,100 Interest...