Question: I've been asked to create a cash versus sales chart and add a trend line. Is cash a consistent percentage of sales? And do a

I've been asked to create a cash versus sales chart and add a trend line. Is cash a consistent percentage of sales? And do a Regression Analysis as well. This is how I did it.

Q.-Do I need to divide cash/sales and use that percentage in order to create the chart and answer whether the percentage of sales is consistent? Or do I just use the cash and sales values as it shows in the picture below? What exactly makes a percentage of sales consistent? Thank you.

If anything, please answer whether the set up is correct and if the regression values are correct as well. Thank you kindly.

I've been asked to create a cash versus sales chart and add

OuickBooks Share Comment Home mert Dram Page Layout Formulas Data Times New Roman - 11 - AA === [Copy romet Painter B ru - 01 - A Clipboard Font Normal Calculation Review View H elp Wrap Test Marge Cant . Alignment Bad Check Cell E Z Conditional Format Furmaling - Table Good E xplanatory. E Neutral Hyperlink Autosum 4 Idea _ ut Delite Formu 21:51 l e 47 0 Sort & Find & File - Sci- Editing $. % Number Suncitivity Styles Celle idem Sensitivity A B C D E F G H I J K L M N O P Q R S T U V W X Cash Sales S.200 52.7 Year 2017 2016 2015 52.7 76.2 797) S 7942S 754.6 S 746.75 729.1 S 729.4 S 2014 1092 72.6 2013 2012 5720. 0 5730. 0 57400 5750.0 5750. 0 5770. 0 5780.0 5790.0 56000 58.00 SUMMARY OUTPUT 67.1296 Regenen Satire Muhiple R R Square 45.05% Adjusted R Sqaure 31 3296 Standard Error 17.33981111 Observations ANOVA F Scancel 3.27951151 0.144383015 1 Regression Residual Total S 9 85.5215016985.5215016 1201.986865 300.4967163 2187.50837 4 5 Coefficients Standard Arnor 422.9672253 192.9175096 -0.460270039 0 .254155504 Star Praire 2.192477118 0.093410398 1.810978055 0.144333015 Lower 95% Lpper 95% Lower 95.06 Lipper 95.0% - 112.6576499 958. 5921005 -112.6576199 958 5921005 1.16591884 0.2051782651.165918314 0.245178765 - . THBS. Ieration Scenario Summary Trend Frest & Reg Anlys 448 PM Type here to search o Bi e re x 9 OR. V.200 OuickBooks Share Comment Home mert Dram Page Layout Formulas Data Times New Roman - 11 - AA === [Copy romet Painter B ru - 01 - A Clipboard Font Normal Calculation Review View H elp Wrap Test Marge Cant . Alignment Bad Check Cell E Z Conditional Format Furmaling - Table Good E xplanatory. E Neutral Hyperlink Autosum 4 Idea _ ut Delite Formu 21:51 l e 47 0 Sort & Find & File - Sci- Editing $. % Number Suncitivity Styles Celle idem Sensitivity A B C D E F G H I J K L M N O P Q R S T U V W X Cash Sales S.200 52.7 Year 2017 2016 2015 52.7 76.2 797) S 7942S 754.6 S 746.75 729.1 S 729.4 S 2014 1092 72.6 2013 2012 5720. 0 5730. 0 57400 5750.0 5750. 0 5770. 0 5780.0 5790.0 56000 58.00 SUMMARY OUTPUT 67.1296 Regenen Satire Muhiple R R Square 45.05% Adjusted R Sqaure 31 3296 Standard Error 17.33981111 Observations ANOVA F Scancel 3.27951151 0.144383015 1 Regression Residual Total S 9 85.5215016985.5215016 1201.986865 300.4967163 2187.50837 4 5 Coefficients Standard Arnor 422.9672253 192.9175096 -0.460270039 0 .254155504 Star Praire 2.192477118 0.093410398 1.810978055 0.144333015 Lower 95% Lpper 95% Lower 95.06 Lipper 95.0% - 112.6576499 958. 5921005 -112.6576199 958 5921005 1.16591884 0.2051782651.165918314 0.245178765 - . THBS. Ieration Scenario Summary Trend Frest & Reg Anlys 448 PM Type here to search o Bi e re x 9 OR. V.200

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I am having trouble with a question for an assignment that I am working on for a class. Here is the assignment: Scenario The potential for corporate fraud is always a consideration when using or even...

Question 1. Using the data in the student spreadsheet file P&G.xlsx (to find the student spreadsheets for Financial Analysis with Microsoft Excel, fifth edition, go to www.cengage.com/finance/mayes)...

Can someone help me solve these questions? See attachments. FINANCIAL FORECASTING Question 1. Using the data in the student spreadsheet file P&G.xlsx (to find the student spreadsheets for Financial...

Can someone help me solve these questions? See attachment FINANCIAL FORECASTING Question 1. Using the data in the student spreadsheet file P&G.xlsx (to find the student spreadsheets for Financial...

Hi there, I need help with my case study for Procter and Gamble Company. Please see attached for instructions. Thanks, Problem One Using the data in the student spreadsheet file P&G.xlsx forecast the...

1. Using the data in the student spreadsheet file P&G.xlsx (to find the student spreadsheets for Financial Analysis with Microsoft Excel, fifth edition, go to www.cengage.com/finance/mayes) forecast...

Problems 1. Using the data in the student spreadsheet file P&G.xlsx (to find the student spreadsheets for Financial Analysis with Microsoft Excel, seventh edition, go to www.cengagebrain.com)...

Using the data in the student spreadsheet file P&G.xlsx (to find the student spreadsheets for Financial Analysis with Microsoft Excel, seventh edition, go to www.cengagebrain.com) forecast the June...

. Using the data below, forecast the June 30, 2011, income statement and balance sheet for Procter & Gamble. Use the percent of sales method and the following assumptions: (1) Sales in FY 2011 will...

Forecast the June 30, 2014, income statement and balance sheet for Procter & Gamble. Use the percent of sales method and the following assumptions" 1) Sales in FY 2014 will be $85,000; 2) The tax...

The atmospheric pressure above a swimming pool changes from 755 to 765 mm of mercury. The bottom of the pool is a rectangle (12 m 24 m). By how much does the force on the bottom of the pool increase?

You are engaged to audit the equity investments held by KIWI COMPANY. In the conduct of the audit, you found the following transactions and other information for the year 2021. (a) The financial...

An operations manager wants to examine the effect of air-jet pressure (in pounds per square inch (psi)) on the breaking strength of yarn. Three different levels of air-jet pressure are to be...

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

Would you use the information that Ryder has found on social media to supplement the applications, or ignore it? Justify your decision.

Should male candidates automatically be rejected from the server positions? Why or why not?

What would you do if you were in Jessicas place? How would you approach the conversation with Ryder about the screening process? How might you bring the scoring criteria into the conversation?