Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the financial statements prepared for Field of Dreams for the 2020 fiscal year, prepare a new Statement of Income, Statement of Changes in
- Based on the financial statements prepared for Field of Dreams for the 2020 fiscal year, prepare a new Statement of Income, Statement of Changes in Equity, and Statement of Financial Position for the year ending December 31, 2021 HINT: Set-up the financial statements so that they show both 2020 and the new 2021 financial data (comparative financial statements).
Use the following conditions to support the creation of the projected financial statements:
- 22% increase in revenue.
- 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.
- 15% increase in salaries.
- 1.3% increase in rental cost for fields.
- 5% increase in administrative expenses.
- New advertising expense of $3000.
- Interest expense for 2021 will be $720, which will still be owed at the end of 2021.
- Corporate tax rate will be at 20%; This amount will still be owing at the end of 2021.
- CCA allowance for combined total non-current assets is 20%.
- $1000 of the term loan will be paid off during the 2021 year.
- Income tax payable from 2020 will be paid in cash during the 2021 year.
- 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, ensure that the 2021 financial statement cells include formulasdo not simply type in the numbers!
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 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,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started