Grader Instructionsaccounting 2019 Projectmiller Nobles 7e13eGrader - Instructions Accounting 2019 Project Miller-Nobles (7e/13e) - Using Excel ChF15/ChF17 v1 P

Grader Instructionsaccounting 2019 Projectmiller Nobles 7e13e ✓ Solved

Grader - Instructions Accounting 2019 Project Miller-Nobles (7e/13e) - Using Excel ChF15/ChF17 v1 Project Description: Miller-Nobles (7e/13e) - Using Excel ChF15/ChM2 v1 Steps to Perform: Step Instructions Points Possible 1 Download and open the excel spreadsheet, Miller-Nobles_7e-13e-Using_Excel_ChF15-ChM2_Start.xlsx. This spreadsheet includes 4 tabs; you will enter all answers on the second, the third, and the fourth tabs, Horizontal Analysis, Vertical Analysis, and Ratios. (All answers should be entered in the blue highlighted cells.) Riverside Sweets, a retail candy store chain, reported the balance sheets for 2018 and 2019, and the income statement for 2019. Additional financial information: a.

75% of net sales are on account. b. Market price of stock is per share on June 30, 2019. c. Annual dividend for 2019 was .50 per share. d. All short-term investments are cash equivalents. Perform a horizontal analysis on the balance sheet for 2018 and 2019. (40 pts) (Always use cell references and formulas where appropriate to receive full credit.

If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.) Perform a vertical analysis on the income statement. Use a minus sign or parentheses for any decreases. (9 pts) (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.) Compute the following ratios.

Do not round your calculations. (26 pts) a. Working Capital b. Current Ratio c. Acid-Test (Quick) Ratio d. Cash Ratio e.

Accounts Receivable Turnover f. Days’ Sales in Receivables g. Inventory Turnover h. Days’ Sales in Inventory i. Gross Profit Percentage j.

Debt Ratio k. Debt to Equity Ratio l. Times-Interest-Earned Ratio m. Profit Margin Ratio n. Rate of Return on Total Assets o.

Asset Turnover Ratio p. Rate of Return on Common Stockholders’ Equity q. Earnings per Share (EPS) r. Price/Earnings Ratio s. Dividend Yield t.

Dividend Payout (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.) Once completed, save the project to the desktop. File name can be anything, but DO NOT include spaces. Return to auto-graded excel activity window, and progress to Step 3.

Follow on screen instructions. (To review score, navigate to Results in the MyLab and click on Review link.) Hint: 0 Total Points 75 Created On: 07/13/2020 1 Miller-Nobles (7e/13e) - Using Excel ChF15/ChF17 v1 Name: NURS_6050_Module02_Week03_Discussion_Rubric Main Posting-- Excellent 45 (45%) - 50 (50%) Answers all parts of the discussion question(s) expectations with reflective critical analysis and synthesis of knowledge gained from the course readings for the module and current credible sources. Supported by at least three current, credible sources. Written clearly and concisely with no grammatical or spelling errors and fully adheres to current APA manual writing rules and style. Good 40 (40%) - 44 (44%) Responds to the discussion question(s) and is reflective with critical analysis and synthesis of knowledge gained from the course readings for the module.

At least 75% of post has exceptional depth and breadth. Supported by at least three credible sources. Written clearly and concisely with one or no grammatical or spelling errors and fully adheres to current APA manual writing rules and style. Fair 35 (35%) - 39 (39%) Responds to some of the discussion question(s). One or two criteria are not addressed or are superficially addressed.

Is somewhat lacking reflection and critical analysis and synthesis. Somewhat represents knowledge gained from the course readings for the module. Post is cited with two credible sources. Written somewhat concisely; may contain more than two spelling or grammatical errors. Contains some APA formatting errors.

Poor 0 (0%) - 34 (34%) Does not respond to the discussion question(s) adequately. Lacks depth or superficially addresses criteria. Lacks reflection and critical analysis and synthesis. Does not represent knowledge gained from the course readings for the module. Contains only one or no credible sources.

Not written clearly or concisely. Contains more than two spelling or grammatical errors. Does not adhere to current APA manual writing rules and style. Main Post: Timeliness-- Excellent 10 (10%) - 10 (10%) Posts main post by day 3. Good 0 (0%) - 0 (0%) Fair 0 (0%) - 0 (0%) Poor 0 (0%) - 0 (0%) Does not post by day 3.

First Response-- Excellent 17 (17%) - 18 (18%) Response exhibits synthesis, critical thinking, and application to practice settings. Communication is professional and respectful to colleagues. Responses to faculty questions are fully answered, if posed. Provides clear, concise opinions and ideas that are supported by at least two scholarly sources. Demonstrates synthesis and understanding of learning objectives.

Response is effectively written in standard, edited English. Good 15 (15%) - 16 (16%) Response exhibits critical thinking and application to practice settings. Communication is professional and respectful to colleagues. Responses to faculty questions are answered, if posed. Provides clear, concise opinions and ideas that are supported by two or more credible sources.

Response is effectively written in standard, edited English. Fair 13 (13%) - 14 (14%) Response is on topic and may have some depth. Responses posted in the discussion may lack effective professional communication. Responses to faculty questions are somewhat answered, if posed. Response may lack clear, concise opinions and ideas, and a few or no credible sources are cited.

Poor 0 (0%) - 12 (12%) Response may not be on topic and lacks depth. Responses posted in the discussion lack effective professional communication. Responses to faculty questions are missing. No credible sources are cited. Second Response-- Excellent 16 (16%) - 17 (17%) Response exhibits synthesis, critical thinking, and application to practice settings.

Communication is professional and respectful to colleagues. Responses to faculty questions are fully answered, if posed. Provides clear, concise opinions and ideas that are supported by at least two scholarly sources. Demonstrates synthesis and understanding of learning objectives. Response is effectively written in standard, edited English.

Good 14 (14%) - 15 (15%) Response exhibits critical thinking and application to practice settings. Communication is professional and respectful to colleagues. Responses to faculty questions are answered, if posed. Provides clear, concise opinions and ideas that are supported by two or more credible sources. Response is effectively written in standard, edited English.

Fair 12 (12%) - 13 (13%) Response is on topic and may have some depth. Responses posted in the discussion may lack effective professional communication. Responses to faculty questions are somewhat answered, if posed. Response may lack clear, concise opinions and ideas, and a few or no credible sources are cited. Poor 0 (0%) - 11 (11%) Response may not be on topic and lacks depth.

Responses posted in the discussion lack effective professional communication. Responses to faculty questions are missing. No credible sources are cited. Participation-- Excellent 5 (5%) - 5 (5%) Meets requirements for participation by posting on three different days. Good 0 (0%) - 0 (0%) Fair 0 (0%) - 0 (0%) Poor 0 (0%) - 0 (0%) Does not meet requirements for participation by posting on 3 different days.

Total Points: 100 Name: NURS_6050_Module02_Week03_Discussion_Rubric Exit Instructions Financial Statement Analysis Using Excel for financial analysis Riverside Sweets, a retail candy store chain, reported the following figures: RIVERSIDE SWEETS Balance Sheet June 30, 2018 and Assets Current Assets: Cash $ 125,000 $ 119,000 Short-term Investments 685,,000 Accounts Receivable 225,,000 Merchandise Inventory 65,,000 Other Current Assets 195,,000 Total Current Assets 1,295,,228,000 Property, Plant, and Equipment 875,,000 Total Assets $ 2,170,000 $ 2,060,000 Liabilities Current Liabilities: Accounts Payable $ 265,000 $ 251,750 Accrued Liabilities 641,,523 Total Current Liabilities 906,,273 Long-term Liabilities Bonds Payable 250,,000 Mortgage Payable 150,,000 Total Long-term Liabilities 400,,000 Total Liabilities 1,306,,302,273 Stockholders' Equity Common Stock, par, 225,000 shares issued and outstanding 225,,000 Paid-In Capital in Excess of Par 58,,000 Retained Earnings 581,,727 Total Stockholders' Equity 864,,727 Total Liabilities and Stockholders' Equity $ 2,170,000 $ 2,060,000 RIVERSIDE SWEETS Income Statement Year Ended June 30, 2019 Net Sales $ 2,800,000 Cost of Goods Sold 1,551,600 Gross Profit 1,248,400 Operating Expenses 450,540 Operating Income 797,860 Other Income and (Expenses) Interest Expense 15,000 Income Before Income Taxes 782,860 Income Tax Expense 153,529 Net Income $ 629,331 Additional financial information: a.

75% of net sales are on account. b. Market price of stock is per share on June 30, 2019. c. Annual dividend for 2019 was .50 per share. d. All short-term investments are cash equivalents. Use the blue shaded areas on the ENTERANSWERS tab for inputs.

ALWAYS use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers. Requirements Possible Points 1 Perform a horizontal analysis on the balance sheet for 2018 and 2019. Perform a vertical analysis on the income statement.

Compute the following ratios. Do not round your calculations. 26 a. Working Capital b. Current Ratio c.

Acid-Test (Quick) Ratio d. Cash Ratio e. Accounts Receivable Turnover f. Days’ Sales in Receivables g. Inventory Turnover h.

Days’ Sales in Inventory i. Gross Profit Percentage j. Debt Ratio k. Debt to Equity Ratio l. Times-Interest-Earned Ratio m.

Profit Margin Ratio n. Rate of Return on Total Assets o. Asset Turnover Ratio p. Rate of Return on Common Stockholders’ Equity q. Earnings per Share (EPS) r.

Price/Earnings Ratio s. Dividend Yield t. Dividend Payout Excel Skills 1 Basic cell formulas Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b.

Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback ENTERANSWERS1 Perform a horizontal analysis on the balance sheets for 2018 and 2019. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.) RIVERSIDE SWEETS Balance Sheet June 30, 2018 and 2019 Increase (Decrease) Amount Percentage Assets Current Assets: Cash $ 125,000 $ 119,000 Short-term Investments 685,,000 Accounts Receivable 225,,000 Merchandise Inventory 65,,000 Other Current Assets 195,,000 Total Current Assets 1,295,,228,000 Property, Plant, and Equipment 875,,000 Total Assets $ 2,170,000 $ 2,060,000 Liabilities Current Liabilities: Accounts Payable $ 265,000 $ 251,750 Accrued Liabilities 641,,523 Total Current Liabilities 906,,273 Long-term Liabilities Bonds Payable 250,,000 Mortgage Payable 150,,000 Total Long-term Liabilities 400,,000 Total Liabilities 1,306,,302,273 Stockholders' Equity Common Stock, par, 225,000 shares issued and outstanding 225,,000 Paid-In Capital in Excess of Par 58,,000 Retained Earnings 581,,727 Total Stockholders' Equity 864,,727 Total Liabilities and Stockholders' Equity $ 2,170,000 $ 2,060,000 HINTS 1.

For cell references, begin the formula with an equals sign (=), use the balance in this worksheet for your calculations, and press the enter key. ENTERANSWERS2 Perform a vertical analysis on the income statement. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.) RIVERSIDE SWEETS Income Statement Year Ended June 30, 2019 Net Sales $ 2,800,000 Cost of Goods Sold 1,551,600 Gross Profit 1,248,400 Operating Expenses 450,540 Operating Income 797,860 Other Income and (Expenses) Interest Expense 15,000 Income Before Income Taxes 782,860 Income Tax Expense 153,529 Net Income $ 629,331 HINTS 1.

For cell references, begin the formula with an equals sign (=), use the income statement in this worksheet for your calculations, and press the enter key. ENTERANSWERS3 Compute the following ratios. Do not round your calculations. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.) Working Capital Current Ratio Acid-Test (Quick) Ratio Cash Ratio Accounts Receivable Turnover Days’ Sales in Receivables Inventory Turnover Days’ Sales in Inventory Gross Profit Percentage Debt Ratio Debt to Equity Ratio Times-Interest-Earned Ratio Profit Margin Ratio Rate of Return on Total Assets Asset Turnover Ratio Rate of Return on Common Stockholders’ Equity Earnings per Share (EPS) Price/Earnings Ratio Dividend Yield Dividend Payout HINTS Cell | Hint: C5 | Begin the formula with an equals sign (=), use the balance in the horizontal analysis worksheet for your calculations, and press the enter key. Ð¡7 | Use the function =SUM( ) to calculate the numerator. C9 | =(0.75*'Vertical Analysis'!C8)/(('Horizontal Analysis'!C14+'Horizontal Analysis'!D14)/2) C10 | Assume 365 days in a year and use the correct ratio in this worksheet for your calculations.

Paper for above instructions

Financial Statement Analysis for Riverside Sweets

Financial statement analysis is a crucial aspect of understanding a company's performance. It involves evaluating financial statements to gain insights into the company's financial health. In this analysis, we will perform a horizontal and vertical analysis of Riverside Sweets' financial statements for the years 2018 and 2019, calculate various financial ratios, and interpret these metrics early for decision-making.

Horizontal Analysis

Horizontal analysis compares financial data over a certain period. In this case, we are looking at the balance sheets of Riverside Sweets for 2018 and 2019. The aim is to measure the increase or decrease in assets, liabilities, and equity over this timeframe.
1. Calculating Increases/Decreases and Percentages:
Here are the key figures extracted from the balance sheet:
- Total Assets:
- 2018:

Grader Instructionsaccounting 2019 Projectmiller Nobles 7e13e

75% of net sales are on account. b. Market price of stock is $36 per share on June 30, 2019. c. Annual dividend for 2019 was $1.50 per share. d. All short-term investments are cash equivalents. Perform a horizontal analysis on the balance sheet for 2018 and 2019. (40 pts) (Always use cell references and formulas where appropriate to receive full credit.

Do not round your calculations. (26 pts) a. Working Capital b. Current Ratio c. Acid-Test (Quick) Ratio d. Cash Ratio e.

Accounts Receivable Turnover f. Days’ Sales in Receivables g. Inventory Turnover h. Days’ Sales in Inventory i. Gross Profit Percentage j.

Debt Ratio k. Debt to Equity Ratio l. Times-Interest-Earned Ratio m. Profit Margin Ratio n. Rate of Return on Total Assets o.

Asset Turnover Ratio p. Rate of Return on Common Stockholders’ Equity q. Earnings per Share (EPS) r. Price/Earnings Ratio s. Dividend Yield t.

Total Points: 100 Name: NURS_6050_Module02_Week03_Discussion_Rubric Exit Instructions Financial Statement Analysis Using Excel for financial analysis Riverside Sweets, a retail candy store chain, reported the following figures: RIVERSIDE SWEETS Balance Sheet June 30, 2018 and Assets Current Assets: Cash $ 125,000 $ 119,000 Short-term Investments 685,,000 Accounts Receivable 225,,000 Merchandise Inventory 65,,000 Other Current Assets 195,,000 Total Current Assets 1,295,,228,000 Property, Plant, and Equipment 875,,000 Total Assets $ 2,170,000 $ 2,060,000 Liabilities Current Liabilities: Accounts Payable $ 265,000 $ 251,750 Accrued Liabilities 641,,523 Total Current Liabilities 906,,273 Long-term Liabilities Bonds Payable 250,,000 Mortgage Payable 150,,000 Total Long-term Liabilities 400,,000 Total Liabilities 1,306,,302,273 Stockholders' Equity Common Stock, $1 par, 225,000 shares issued and outstanding 225,,000 Paid-In Capital in Excess of Par 58,,000 Retained Earnings 581,,727 Total Stockholders' Equity 864,,727 Total Liabilities and Stockholders' Equity $ 2,170,000 $ 2,060,000 RIVERSIDE SWEETS Income Statement Year Ended June 30, 2019 Net Sales $ 2,800,000 Cost of Goods Sold 1,551,600 Gross Profit 1,248,400 Operating Expenses 450,540 Operating Income 797,860 Other Income and (Expenses) Interest Expense 15,000 Income Before Income Taxes 782,860 Income Tax Expense 153,529 Net Income $ 629,331 Additional financial information: a.

75% of net sales are on account. b. Market price of stock is $36 per share on June 30, 2019. c. Annual dividend for 2019 was $1.50 per share. d. All short-term investments are cash equivalents. Use the blue shaded areas on the ENTERANSWERS tab for inputs.

Compute the following ratios. Do not round your calculations. 26 a. Working Capital b. Current Ratio c.

Acid-Test (Quick) Ratio d. Cash Ratio e. Accounts Receivable Turnover f. Days’ Sales in Receivables g. Inventory Turnover h.

Days’ Sales in Inventory i. Gross Profit Percentage j. Debt Ratio k. Debt to Equity Ratio l. Times-Interest-Earned Ratio m.

Profit Margin Ratio n. Rate of Return on Total Assets o. Asset Turnover Ratio p. Rate of Return on Common Stockholders’ Equity q. Earnings per Share (EPS) r.

Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback ENTERANSWERS1 Perform a horizontal analysis on the balance sheets for 2018 and 2019. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.) RIVERSIDE SWEETS Balance Sheet June 30, 2018 and 2019 Increase (Decrease) Amount Percentage Assets Current Assets: Cash $ 125,000 $ 119,000 Short-term Investments 685,,000 Accounts Receivable 225,,000 Merchandise Inventory 65,,000 Other Current Assets 195,,000 Total Current Assets 1,295,,228,000 Property, Plant, and Equipment 875,,000 Total Assets $ 2,170,000 $ 2,060,000 Liabilities Current Liabilities: Accounts Payable $ 265,000 $ 251,750 Accrued Liabilities 641,,523 Total Current Liabilities 906,,273 Long-term Liabilities Bonds Payable 250,,000 Mortgage Payable 150,,000 Total Long-term Liabilities 400,,000 Total Liabilities 1,306,,302,273 Stockholders' Equity Common Stock, $1 par, 225,000 shares issued and outstanding 225,,000 Paid-In Capital in Excess of Par 58,,000 Retained Earnings 581,,727 Total Stockholders' Equity 864,,727 Total Liabilities and Stockholders' Equity $ 2,170,000 $ 2,060,000 HINTS 1.

,170,000
- 2019: