Ending Balance Sheet Make sure you read the pdf linked above Cash Gross receivables in $ [No allowance or deferred revenues.] Inventories in $ [No accounts payable] Prepaid insurance or deferred insurance expense in $ Net PP&E in $ Accrued salaries or salary payable in $ Taxes payable Paid-in Capital Retained earnings Year 1 Year 3 (THREE) 30 500 Checks Year 1 Year 2 Year 3 Steps C1: NI - Dividends - Change in RE = 0 C2: Net cash flow - Change in cash = 0 C3: A (LE)=0 ཨཱཐཱ། 9 20 26 Inputs Year 1 Year 2 Year 3 Income statement Sales for which cash is received after the sale COGS Salary expense Insurance expense Depreciation expense Tax rate Operating cash flows Cash received from customers Cash (paid) to suppliers of inventory [= Purchases, since accounts payable = 0] Cash (paid) for salaries Cash (paid) for insurance Taxes (paid) Investing cash flows (Purchase of PP&E or capital expenditures) Financing cash flows Stock issued (Dividends) paid 1000.00 1200.00 1445.00 145.00 223.00 212.00 27 400.00 257.00 134.00 110.00 89.00 54 25.00% 25.00% 25.00% 63 970.00 1070.00 1290.00 10 -200.00 -210.00 -290.00 30 -330.00 -402.00 -600.00 39 -350.00 -270.00 -367.00 48 -12.00 -15.00 -22.00 66 -400.00 -100.00 -110.00 57 498.00 712.00 36 289.00 324.00 45 500.00 25.00 -10.00 -11.00 35.00 72 -12.00 79 122418228 22
Ending Balance Sheet Make sure you read the pdf linked above Cash Gross receivables in $ [No allowance or deferred revenues.] Inventories in $ [No accounts payable] Prepaid insurance or deferred insurance expense in $ Net PP&E in $ Accrued salaries or salary payable in $ Taxes payable Paid-in Capital Retained earnings Year 1 Year 3 (THREE) 30 500 Checks Year 1 Year 2 Year 3 Steps C1: NI - Dividends - Change in RE = 0 C2: Net cash flow - Change in cash = 0 C3: A (LE)=0 ཨཱཐཱ། 9 20 26 Inputs Year 1 Year 2 Year 3 Income statement Sales for which cash is received after the sale COGS Salary expense Insurance expense Depreciation expense Tax rate Operating cash flows Cash received from customers Cash (paid) to suppliers of inventory [= Purchases, since accounts payable = 0] Cash (paid) for salaries Cash (paid) for insurance Taxes (paid) Investing cash flows (Purchase of PP&E or capital expenditures) Financing cash flows Stock issued (Dividends) paid 1000.00 1200.00 1445.00 145.00 223.00 212.00 27 400.00 257.00 134.00 110.00 89.00 54 25.00% 25.00% 25.00% 63 970.00 1070.00 1290.00 10 -200.00 -210.00 -290.00 30 -330.00 -402.00 -600.00 39 -350.00 -270.00 -367.00 48 -12.00 -15.00 -22.00 66 -400.00 -100.00 -110.00 57 498.00 712.00 36 289.00 324.00 45 500.00 25.00 -10.00 -11.00 35.00 72 -12.00 79 122418228 22
Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter12: Fainancial Statement Analysis
Section: Chapter Questions
Problem 16MCQ
Related questions
Question
Hi,
Please help me solve for the orange boxes using the information in the excel. that is all the information you need
![Ending Balance Sheet
Make sure you read the pdf linked above
Cash
Gross receivables in $ [No allowance or deferred revenues.]
Inventories in $ [No accounts payable]
Prepaid insurance or deferred insurance expense in $
Net PP&E in $
Accrued salaries or salary payable in $
Taxes payable
Paid-in Capital
Retained earnings
Year 1 Year 3 (THREE)
30
500](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F99d6c510-5b8c-4c17-ac3a-87bddda960ff%2F4f0ef32b-ca37-48e5-8def-76b22023068d%2Fnwi7h6m_processed.png&w=3840&q=75)
Transcribed Image Text:Ending Balance Sheet
Make sure you read the pdf linked above
Cash
Gross receivables in $ [No allowance or deferred revenues.]
Inventories in $ [No accounts payable]
Prepaid insurance or deferred insurance expense in $
Net PP&E in $
Accrued salaries or salary payable in $
Taxes payable
Paid-in Capital
Retained earnings
Year 1 Year 3 (THREE)
30
500
![Checks
Year 1
Year 2
Year 3
Steps
C1: NI - Dividends - Change in RE = 0
C2: Net cash flow - Change in cash = 0
C3: A (LE)=0
ཨཱཐཱ།
9
20
26
Inputs
Year 1
Year 2
Year 3
Income statement
Sales for which cash is received after the sale
COGS
Salary expense
Insurance expense
Depreciation expense
Tax rate
Operating cash flows
Cash received from customers
Cash (paid) to suppliers of inventory
[= Purchases, since accounts payable = 0]
Cash (paid) for salaries
Cash (paid) for insurance
Taxes (paid)
Investing cash flows
(Purchase of PP&E or capital expenditures)
Financing cash flows
Stock issued
(Dividends) paid
1000.00 1200.00 1445.00
145.00 223.00 212.00 27
400.00
257.00
134.00 110.00
89.00 54
25.00% 25.00% 25.00% 63
970.00 1070.00 1290.00 10
-200.00 -210.00 -290.00 30
-330.00 -402.00 -600.00 39
-350.00 -270.00 -367.00 48
-12.00 -15.00 -22.00 66
-400.00 -100.00 -110.00 57
498.00 712.00
36
289.00 324.00 45
500.00 25.00
-10.00 -11.00
35.00
72
-12.00 79
122418228 22](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F99d6c510-5b8c-4c17-ac3a-87bddda960ff%2F4f0ef32b-ca37-48e5-8def-76b22023068d%2Fudsekta_processed.png&w=3840&q=75)
Transcribed Image Text:Checks
Year 1
Year 2
Year 3
Steps
C1: NI - Dividends - Change in RE = 0
C2: Net cash flow - Change in cash = 0
C3: A (LE)=0
ཨཱཐཱ།
9
20
26
Inputs
Year 1
Year 2
Year 3
Income statement
Sales for which cash is received after the sale
COGS
Salary expense
Insurance expense
Depreciation expense
Tax rate
Operating cash flows
Cash received from customers
Cash (paid) to suppliers of inventory
[= Purchases, since accounts payable = 0]
Cash (paid) for salaries
Cash (paid) for insurance
Taxes (paid)
Investing cash flows
(Purchase of PP&E or capital expenditures)
Financing cash flows
Stock issued
(Dividends) paid
1000.00 1200.00 1445.00
145.00 223.00 212.00 27
400.00
257.00
134.00 110.00
89.00 54
25.00% 25.00% 25.00% 63
970.00 1070.00 1290.00 10
-200.00 -210.00 -290.00 30
-330.00 -402.00 -600.00 39
-350.00 -270.00 -367.00 48
-12.00 -15.00 -22.00 66
-400.00 -100.00 -110.00 57
498.00 712.00
36
289.00 324.00 45
500.00 25.00
-10.00 -11.00
35.00
72
-12.00 79
122418228 22
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,