Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The income statement figures for the past three years for Victorian Manor are presented below. Victorian Manor Income statements for the period 2018 to 2020

The income statement figures for the past three years for Victorian Manor are presented below.

Victorian Manor

Income statements for the period 2018 to 2020

2018

2019

2020

Sales revenue

134000

95000

147000

Interest revenue

33500

5700

36800

Total revenue

167500

100700

183800

Expenses

Cost of goods sold

46900

47500

72000

Advertising expense

2700

3800

7400

Insurance expense

2700

4800

2900

Rent expense

5400

1900

2900

Utilities expense

2700

2900

4400

Depreciation expense

18800

10500

19100

Wages and salaries expense

2700

2900

2900

Interest expense

2700

1900

5900

Total expenses

84600

76200

117500

Profit

82900

24500

66300

Required:

a. Using the information prepare a trend analysis. (Round all answers to 2 decimal places, e.g. 15.25.) b. Using the information prepare a vertical analysis (using total revenue as the base amount). (Round all answers to 2 decimal places, e.g. 15.25.)

a. Trend analysis.

Victorian Manor

Trend analysis

2018

2019

2020

Sales revenue

Answer

Answer

Answer

Interest revenue

Answer

Answer

Answer

Total revenue

Answer

Answer

Answer

Expenses

Cost of goods sold

Answer

Answer

Answer

Advertising expense

Answer

Answer

Answer

Insurance expense

Answer

Answer

Answer

Rent expense

Answer

Answer

Answer

Utilities expense

Answer

Answer

Answer

Depreciation expense

Answer

Answer

Answer

Wages and salaries expense

Answer

Answer

Answer

Interest expense

Answer

Answer

Answer

Total expenses

Answer

Answer

Answer

Profit

Answer

Answer

Answer

b. Vertical analysis (using total revenue as the base amount).

Victorian Manor

Vertical analysis

2018

2019

2020

%

%

%

Sales revenue

Answer

Answer

Answer

Interest revenue

Answer

Answer

Answer

Total revenue

Answer

Answer

Answer

Expenses

Cost of goods sold

Answer

Answer

Answer

Advertising expense

Answer

Answer

Answer

Insurance expense

Answer

Answer

Answer

Rent expense

Answer

Answer

Answer

Utilities expense

Answer

Answer

Answer

Depreciation expense

Answer

Answer

Answer

Wages and salaries expense

Answer

Answer

Answer

Interest expense

Answer

Answer

Answer

Total expenses

Answer

Answer

Answer

Profit

Answer

Answer

Answer

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

The Audit Process Principles Practice And Cases

Authors: Iain Gray, Louise Crawford, Stuart Manson

7th Edition

1473760186, 9781473760189

More Books

Students also viewed these Accounting questions

Question

Solve each equation. Check the solutions. 15 X = 2x 1

Answered: 1 week ago

Question

(Appendix) What are sales returns? Why do sales returns occur? LO86

Answered: 1 week ago