Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Below is a Statement of Income, Statement of Changes in Equity, and Statement of Financial Position for Field of Dreams for the year 2020, make

Below is a Statement of Income, Statement of Changes in Equity, and Statement of Financial Position for Field of Dreams for the year 2020, make a new Statement of Income, Statement of Changes in Equity, and Statement of Financial Position for the year 2021 using the information below. The new statements should include both information 2020 and 2021

2021 Statement should have the following:

  1. 22% increase in revenue.
  2. All accounts receivables from 2020 will be collected as cash in 2021; 15% of the 2021 revenue will be outstanding as a receivable at the end of the 2021 year.
  3. 15% increase in salaries.
  4. 1.3% increase in rental cost for fields.
  5. 5% increase in administrative expenses.
  6. New advertising expense of $3000.
  7. Interest expense for 2021 will be $720, which will still be owed at the end of 2021.
  8. Corporate tax rate will be at 20%; This amount will still be owing at the end of 2021.
  9. CCA allowance for combined total non-current assets is 20%.
  10. $1000 of the term loan will be paid off during the 2021 year.
  11. Income tax payable from 2020 will be paid in cash during the 2021 year.
  12. Jason Tyrells dividend payout for 2021 will increase by 5%.

Note: For the projected Statement of Income, Statement of Changes in Equity, and Statement of Financial Position, make sure that the 2021 financial statement cells include formulas on how it was calculated!do not simply type in the numbers! Thanks!

image text in transcribed

image text in transcribed

image text in transcribed

Field of Dreams Statement of Income for the period ending December 31, 2020 2020 Revenue 100,000 Cost of sales COGS Total cost of sales 0 Gross profit 100,000 Expenses Salaries expense Field rental expense Adminisrative expense Insurance expense Interest expense Depreciation/amortization Other charges Total expenses 20,000 14,000 7,000 6,000 800 0 0 47,800 Profit before taxes 52,200 Income taxe expense 10,4401 Profit for the year 41,760 Field of Dreams Statement of Changes in Equity For the period ending December 31, 2020 2020 Common shares Balance at beginning of year Common shares issued Other changes Balance at end of year 5,000 5,000 Retained earnings Balance at beginning of year Profit applicable to common shareholders Sub-total Dividends paid to shareholders Balance at end of year 41,760 41,760 35,000 6,760 Total shareholders' equity 11,760 Field of Dreams Statement of Financial Position As at December 31, 2020 2020 Assets Non-current assets Bus Equipment Sub-total Accumulated depreciation/amortization 12,000 1,500 13,500 0 13,500 9,500 10,000 19,500 33,000 Total non-current assets Current assets Cash Trade receivables Total current assets Total assets Equity and liabilities Share capital Retained earnings Total shareholders equity Non-current liabilities Bank Loan (10 year term loan) Total Non-current liabilities Current liabilities Interest payable Income Tax Payable Other accounts payable 5,000 6,760 11,760 10,000 10,000 800 10,440 0 Total current liabilities 11,240 Total labilities 21,240 Total equity and liabilities 33,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Finance questions