Homework Help is Here – Start Your Trial Now!
Business
Accounting
Assumptions (Currency: €) Cap. ex €1000 Asset life 10 years Cash from sales €1200 per year Cost of goods sold (COGS) €700 (all paid in cash not stock at the year end) SG&A (exclude depreciation) €150 (all paid in cash) Staff €100 Owner equity €700 1) Build a spreadsheet that forecasts the cash flow, income statement and balance sheet of ABC for 3 year

Assumptions (Currency: €) Cap. ex €1000 Asset life 10 years Cash from sales €1200 per year Cost of goods sold (COGS) €700 (all paid in cash not stock at the year end) SG&A (exclude depreciation) €150 (all paid in cash) Staff €100 Owner equity €700 1) Build a spreadsheet that forecasts the cash flow, income statement and balance sheet of ABC for 3 year

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

Assumptions (Currency: €)

Cap. ex €1000
Asset life 10 years
Cash from sales €1200 per year
Cost of goods sold (COGS) €700 (all paid in cash not stock at the year end)
SG&A (exclude depreciation) €150 (all paid in cash)
Staff €100
Owner equity €700

1) Build a spreadsheet that forecasts the cash flow, income statement and balance sheet of ABC for 3 year

Cash flow projections (indirect methodl Year 1 Year 2 Year 3 Cash flow from sales Depreciation Cash from operations CAP&X Cash from investing Owners equity Cash from financing Beginning cash balance Total change in cash Ending cash balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Income statement Year 1 Year 2 Year 3 Sales COGS Gross profit SG&A Satff Depreciation Net Profit Balance sheet Cost of assets Less accumuleted depreciation Net Book Value of Assset Current assets Bank Assets Capital and reserve Share capital Retained profit Liabilities Tolo o
Transcribed Image Text:Cash flow projections (indirect methodl Year 1 Year 2 Year 3 Cash flow from sales Depreciation Cash from operations CAP&X Cash from investing Owners equity Cash from financing Beginning cash balance Total change in cash Ending cash balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Income statement Year 1 Year 2 Year 3 Sales COGS Gross profit SG&A Satff Depreciation Net Profit Balance sheet Cost of assets Less accumuleted depreciation Net Book Value of Assset Current assets Bank Assets Capital and reserve Share capital Retained profit Liabilities Tolo o
Statement of Cash Flows (direct method) Year 1 Year 2. Year 3. Cash receipts from customers Cash paid to suppliers Cash paid to employees Cash generated from operations Interest paid Income taxes paid Net cash from operating activities Net cash used in investing activities Net cash used in financing activities Beginning cash balance Net change in cash and cash equivalents Ending cash balance 3O0 OO 200 OO O O Oo O O O
Transcribed Image Text:Statement of Cash Flows (direct method) Year 1 Year 2. Year 3. Cash receipts from customers Cash paid to suppliers Cash paid to employees Cash generated from operations Interest paid Income taxes paid Net cash from operating activities Net cash used in investing activities Net cash used in financing activities Beginning cash balance Net change in cash and cash equivalents Ending cash balance 3O0 OO 200 OO O O Oo O O O
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Investments and Financial instruments
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS