Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The table below shows a number of items from the balance sheet and income statement of Fields Inc. 1. Prepare a pivot table showing the

The table below shows a number of items from the balance sheet and income statement of Fields Inc.

1. Prepare a pivot table showing the profit margin and the return on assets, by quarter. You should have one pivot table with the dates in the first column, profit margins in the second column and ROA in the third column.

2. Prepare a graph showing Profit margin and ROA by quarter.

Date Sales Net Income Profit Margin Total Assets ROA
Dec-15 $8,440.00 $2,543.00 30.13% 57851 4.40%
Sep-15 $7,286.00 $2,167.00 29.74% 53342 4.06%
Jun-15 $6,820.00 $1,840.00 26.98% 48045 3.83%
Mar-15 $6,775.00 $1,955.00 28.86% 42871 4.56%
Dec-14 $6,674.00 $1,974.00 29.58% 40497 4.87%
Sep-14 $5,945.00 $1,639.00 27.57% 37703 4.35%
Jun-14 $5,523.00 $1,485.00 26.89% 35159 4.22%
Mar-14 $5,509.00 $1,423.00 25.83% 33513 4.25%
Dec-13 $5,701.00 $382.00 6.70% 31768 1.20%
Sep-13 $5,541.00 $1,290.00 23.28% 30807 4.19%
Jun-13 $5,367.00 $1,247.00 23.23% 29180 4.27%
Mar-13 $5,186.00 $1,307.00 25.20% 27605 4.73%
Dec-12 $4,827.00 $1,206.00 24.98% 25336 4.76%
Sep-12 $4,231.00 $1,070.00 25.29% 23341 4.58%
Jun-12 $3,872.00 $925.00 23.89% 21424 4.32%
Mar-12 $3,664.00 $1,002.00 27.35% 20015 5.01%
Dec-11 $3,206.00 $1,031.00 32.16% 18473 5.58%
Sep-11 $2,690.00 $733.00 27.25% 15693 4.67%
Jun-11 $2,456.00 $721.00 29.36% 14396 5.01%
Mar-11 $2,254.00 $592.00 26.26% 11295 5.24%

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

Personal Financial Planning For Executives And Entrepreneurs

Authors: Michael J. Nathanson, Jeffrey T. Craig, Jennifer A. Geoghegan, Nadine Gordon Lee, Michael A. Haber, Seth P. Hieken, Matthew C. Ilteris, D. Scott McDonald, Joseph A. Salvati, Stephen R. Stelljes

1st Edition

3030405273, 978-3030405274

More Books

Students also viewed these Finance questions

Question

Design a job advertisement.

Answered: 1 week ago