Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. it has come to your attention that someone in the

It has come to your attention that someone in the company has not been consistent in...

70.2K

Verified Solution

Question

Accounting

  1. It has come to your attention that someone in the company hasnot been consistent in entering financial data – some years aremissing the relative percentage change or the net profit aspresented below in Table 1.  You are required tocalculate the Relative Percentage Change in the company for theblanks below and the Net Profit for the other blanks.

Show all working outbelow including the formula used for each year and include thecompleted table here.

Year

2010

2011

2012

2013

2014

2015

2016

2017

2018

2019

Net Profit ($ 000’)

50

200

150

225

250

200

250

260

Relative Percentage Change

N/A

-50%

300%

50%

11%

-30%

14%

25%

               Table1: Net Profit ($) per financial year

  1. Using Excel, create a column chartof the NetProfit calculated in part (a) for the years 2010-2019. For fullmarks, label the axis and provide an appropriate title.

(c) Using Excel, create aSparkling of the Relative Percentage Change calculated inpart (a) for the years 2011-2019. For full marks, use theSparkling options to mark if there are any negative valuesand include a horizontal axis to easily visualise changes. Thesparkline should be included here however you will also use it inthe report body text.

Answer & Explanation Solved by verified expert
4.2 Ratings (804 Votes)
AnsaCompleted Profit Table    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Biology
1.2K views

You are on a jury in which a potential murderer was identified by a fingerprint, how...

Biology
1.2K views

Evolution is best defined as a the inheritance of an acquired characteristic Ob any change...

Basic Math
1.2K views

Determine the mean, median, mode, and midrange of the set of data.1, 9, 10, 26,...

Accounting
1.2K views

$13,000 loan on a used car that will be repaid in monthly installments for 4...

Accounting
1.2K views

Steven Company has fixed costs of $375,156. The unit selling price, variable cost per unit,...

Accounting
1.2K views

Lowell owns 80% of Boston. At the end of the year when Lowell consolidates with...

Accounting
1.2K views

Case B Samuda Enterprises uses the aging approach to estimate bad debt expense. At the...

Accounting
1.2K views

100 Cash at Dank 110 Accounts receivable 120 Inventory 130 Prepaid insurance 171 Shop equipment...

Accounting
1.2K views

The method of budgeting that adds one month's budget to the end of the plan...

Accounting
1.2K views

Requirement 1. What is the company's breakeven point in units, assuming that the given sales...

Accounting
1.2K views

how do you express on a journal entry: purchasing plumbing equipment for $25,000 making a...

Finance
1.2K views

Question 4 (10 points) Saved Listen Dandy Product's overall weighted average required rate of return...