Urgent! I need help with my accounting homework it is a Excel spreadsheet that will be attached. Please anything is helpful!!!

Nova Southeastern University H. Wayne Huizenga College of Business & Entrepreneurship Assignment for Course: ACT 5140 Accounting for Decision Makers Submitted to: Prof. Allen Yessman Submitted by: Date of Submission: Title of Assignment: National Beverage Corp. Analysis CERTIFICATION OF AUTHORSHIP: I certify that I am the author of this paper and that any preparation is fully acknowledged and disclosed in the paper. I have also cited any sources or words, either quoted directly or paraphrased. I also certify that this paper was prepared b course. Student's Signature: ********************************************************************************* Instructor's Grade on Assignment: Instructor's Comments: Ratios equal 40% of the grade Each calculation not correctly computed is a deduction of 1/146 of a point x 40% 28% (example) The calculation not correct is highlighted in red========> Assessment Analysis is worth 60% of grade (Each page of assessments is worth 10% x 6 pages) Calculations for Assignm Ratios Score =====================================> Assessment Score =================================> Final Grade for Assignment ===========================================> Total Incorrect Ratios Computed Correct Ratios Computed Total Ratios to Compute Score For Ratios Important Note: When submitting assignment please rename file (Last Name) (First Name), National Beverag Fill in Your Name in the two Areas Please Be Sure You Read Notes Submitting Pap Please Submit both Papers to Bb AND Upload to "One Drive" and Share with me (This Excel Worksheet and the Word Doc) 40 60 100 0 146 146 100.00 X 40% = 40 assignment please rename file as follows: ) (First Name), National Beverage Analysis R E A D e Sure You Read Notes Above Submitting Paper Before ND th me Doc) Assignment Grade 100 100 ACT 5140 - Accounting for Decision Makers National Beverage Corp. Assignment Due 06-24-2017 Directions: Answer all the questions. Please use this Excel workbook for your all Be sure to show how you did your calculations in the cells for each answer. Als PM on June 24, 2017. To do the best paper you should use information from various areas of each of MD&A (Management's Discussion and Analysis) and Notes to the financial stat even more valuable in doing your analysis. It is best to be familiar with what is Since this project will take some time to do, it is best that you begin this projec There are 2 Parts to the project. (1) Prepare this Excel Workbook for the computa be in coherent proper English and will be graded for grammar as well as content. Part 1 - Excel Sheet Prepare Ratios Prepare the Ratios for National Beverage Corp. concerning liquidity, solvency, p each area, you should calculate the ratios we discussed in class and provide an share information below. Note: It is best to prepare the Part 1 ratios right after you understand the ratio get these ratios done in an expedient manner you will then have 4 weeks or mo Part 2 - Separate Word Document Prepare Analyses Prepare a Word Analyses Document with the following headings and prepare y each ratio prepared. 1. Short Term Ratios Analyses 2. Long Term Ratios Analyses 3. Profitability Ratios Analyses 4. Explanation of DuPont Theory This are does not require any analyses of ratios since most of these should a Therefore I want you to Explain the DuPont Theory with a minimum of 200 w 5. Stock Ratios Analyses 6. Vertical and Horizontal Analyses 1. Explain why not all the Fiscal Years Ended listed for National Beverage be 2. For the Vertical and Horizontal Analyses only, explain several notable Rati are trying to make about the company. Final Note: It is important that you use information from the annual reports to get the be it will clear up reasons why ratios changed. The best places to look are in the managment throughout the report also provide excellent information about the company. Remember Final Note: It is important that you use information from the annual reports to get the be it will clear up reasons why ratios changed. The best places to look are in the managment throughout the report also provide excellent information about the company. Remember Fiscal Year Ended Adjusted Closing Price Common Shares Outstanding thousands) 4/30/2016 $ (in Basic EPS Dilutive EPS Weighted Average Shares - Basic Weighted Average Shares - Diluted Adjusted Closing Price (Yahoo Finance) $ 46.74 $ 5/2/2015 22.42 50,589 50,418 1.31 1.31 46,452 46,671 1.06 1.06 46,353 46,559 46.74 $ 22.42 xcel workbook for your all of your ratio answers. Nothing else needs to be submitted except t cells for each answer. Also, please be sure to fill out all information in the coversheet provide m various areas of each of the four Annual Reports provided for National Beverage as a basis fo Notes to the financial statements are a good place to start, but there are other areas in the An o be familiar with what is in each of the Annual Reports provided before starting any analysis that you begin this project as soon as possible. If you have any questions, please e-mail me at Workbook for the computations of the ratios (2) Prepare a Word Document for the Ratio Analys ammar as well as content. Be sure you proof read your work several times before handing it in rning liquidity, solvency, profitability, DuPont, and stock performance as of April 30, 2016 and ed in class and provide an analysis of the ratios calculated. I include historical stock price infor you understand the ratios found in Homework 1 since this information will be the freshest in l then have 4 weeks or more to prepare a wonderful written analysis of the ratios you prepare ng headings and prepare you analyses like that shown in "Example Analysis" (See Black Tab lab ce most of these should already have been analyzed with the Profitability Ratios y with a minimum of 200 words to prove you understand what the DuPont Theory is all about for National Beverage below do not fall on the last day of April. xplain several notable Ratios (you do not have to explain all of them) that have the most annual reports to get the best grade for your analysis work. I have downloaded the annual reports for you o look are in the managment discussion and analysis (Commonly known as MD&A) and the notes to the fin out the company. Remember at least 5 references that will be done in the Word Document must be cited a annual reports to get the best grade for your analysis work. I have downloaded the annual reports for you o look are in the managment discussion and analysis (Commonly known as MD&A) and the notes to the fin out the company. Remember at least 5 references that will be done in the Word Document must be cited a 5/3/2014 $ $ 19.21 $ 4/27/2013 14.57 (as reported by National Beverage) 50,368 50,362 0.93 0.92 46,331 46,519 1.01 1.01 46,310 46,482 19.21 $ 14.57 submitted except this Excel Workbook for these ratios. coversheet provided. The assignment is due by 11:59 everage as a basis for some of your answers. The her areas in the Annual Report that can prove to be tarting any analysis work. please e-mail me at yessman@nova.edu. Good luck! or the Ratio Analysis work. This Word Document must before handing it in to be graded. April 30, 2016 and prior statement information. For cal stock price information and outstanding common l be the freshest in your memory at this point. If you e ratios you prepared. (see part 2 requirements below) " (See Black Tab labeled Example Analysis) below for ty Ratios t Theory is all about hat have the most meaning to prove the analysis you annual reports for you, so please use them. In many instances nd the notes to the financial statements, but other areas ument must be cited and contain the foot note reference. annual reports for you, so please use them. In many instances nd the notes to the financial statements, but other areas ument must be cited and contain the foot note reference. You will see below 3 "green" tabs and 6 "red tabs". Green Tabs Represent the information you will need to compute the answers required in the r The Red tabs represent where you will calculate your ratios. In each box where a calcuclated amount is required be sure to show the excel formula of the r I have prepared one ratio for you in the 1-Short Term Tab as an example Legend for Tabs Listed Below answers required in the red tabs. the excel formula of the ratio you calculate. n example Green Tabs - Information Required for Red Tab Answers Historical Stock Prices found on "1-Instructions" 1. IS - Income Statement 2. BS - Balance Sheet 3. SCF - Statement of Cash Flows Red Tabs - You will supply your answers in these tabs In the Boxes you will put your calculations for the ratio required 1. Short-Term - Answers to your short term ratios 2. Long-Term - Answers to your long term ratios 3. Profitability - Answers to your profitability ratios 4. DuPont Analysis - Answers to your DuPont Analysis ratios 5. Stock - Answers to your Stock ratios 6. Vert-Horiz Analysis - Information to be used in your Word D ratio analysis will be performed here since they have already b red for Red Tab Answers n "1-Instructions" ws answers in these tabs alculations for the ratio required o your short term ratios o your long term ratios o your profitability ratios o your DuPont Analysis ratios o your Stock ratios ation to be used in your Word Document Analysis and no d here since they have already been computed. You will prepare in the additional Word Document this type of an analysis to complete the as additional Word Document that you will prepare with your written analyses Partial Example of Short Term Analysis: The current ratio for X Company has been decreasing across fiscal 20X4 and 20X1 im To better show this trend, the working capital has also decreased from $2000 in 20X1 t decreasing during this same period. The decline may mean that X Company may not h the company, in their annual reports, will tell you why this is happening if possible to pro more meaningful way.) The inventory turnover for X Company has been increasing (or decreasing if that is wh went from X in 20X1 to X+ in 20X4. The increase (or decrease if that's what happened) in the number of days to collect rec future periods compound the ability to pay current liabilities as they become due. This is only a sampling of an example. This kind of analysis can be done for each of the ratios computed in the section analysis to complete the assignment. You will turn in 2 documents for this assignment. (1) This Excel D n analyses fiscal 20X4 and 20X1 implying that the company is less liquid and is not the best short term risk. sed from $2000 in 20X1 to $500 in 20X4. Finally, it can also be seen that the acid test ratio has al at X Company may not have enough short term assets to cover additional liabilities. (You may a appening if possible to provide more credence for your answer. You can do this for any ratio you w r decreasing if that is what is happening) across the years provided shows greater efficiency in its ber of days to collect receivable balances may show that the economy in this industry is slowing d they become due. omputed in the section you are working on. signment. (1) This Excel Document (2) An the best short term risk. the acid test ratio has also been al liabilities. (You may also want to see if do this for any ratio you want to explain in a ws greater efficiency in its buying. This ratio n this industry is slowing down which may in National Beverage Corp. Annual Reports Income Statement (Amounts in thousands except per share data) Fiscal Year Ended Net sales Cost of sales Gross profit Expenses: Selling, general and administrative Other operating expense (income)net Interest expense Total Expenses Income before income taxes Provision for income taxes Net income Basic EPS Diluted EPS Dividends Per Share 4/30/2016 $ $ 5/2/2015 5/3/2014 4/27/2013 704,785 $ 463,348 241,437 645,825 $ 426,685 219,140 641,135 $ 423,480 217,655 662,007 444,757 217,250 148,384 145 203 148,732 92,705 31,507 61,198 $ 145,157 (1,101) 371 144,427 74,713 25,402 49,311 $ 153,220 666 660 154,546 63,109 19,474 43,635 $ 146,223 173 403 146,799 70,451 23,531 46,920 $1.31 $1.31 $0.00 $1.06 $1.05 $0.00 $0.93 $0.92 $0.00 $1.01 $1.01 $2.55 National Beverage Corp. Annual Reports Balance Sheet (Amounts in thousands) Fiscal Year Ended ASSETS Current assets: Cash and equivalents Trade receivablesnet Inventories Deferred income taxesnet Prepaid and other assets Total current assets 4/30/2016 4/27/2013 $ 105,577 $ 61,046 47,922 ### ### 223,671 $ 52,456 $ 59,951 42,924 ### ### 167,729 $ 29,932 $ 58,205 43,914 ### ### 143,141 $ 18,267 64,069 39,234 ### ### 130,941 $ 61,932 13,145 ### ### 305,498 $ 60,182 ### ### ### 247,750 $ 59,494 13,145 ### ### 222,841 $ 57,307 13,145 ### ### 208,642 $ 49,391 $ 26,195 28 44,896 $ 21,257 98 45,606 $ 18,873 44 44,261 19,142 34 $ 75,614 $ 66,251 $ 64,523 $ 63,437 Long Term Notes Payable Deferred income taxes - net 14,474 10,000 15,245 30,000 13,873 50,000 14,327 Other liabilities Total liabilties 9,258 99,346 $ 8,472 99,968 $ 8,244 116,640 $ 10,562 138,326 150 $ 506 270 $ 504 390 $ 504 550 504 Property, plant and equipmentnet Goodwill Intangible assets Other assets Total assets $ 5/3/2014 5/2/2015 LIABILITIES AND SHAREHOLDERS EQUITY Current liabilities: Accounts payable Accrued liabilities Income taxes payable Total current liabilities $ Shareholders' equity: Preferred Stock Common Stock $ Additional Paid in Capital (Assume all Common) 1 Retained Earnings 34,570 190,733 37,759 129,773 42,775 80,737 50,398 37,828 (2,524) (205) (964) (18,000) (18,000) 106,201 70,316 (also assume no dividends will be paid to preferred stockholders) Accumulated other comprehensive income (loss) (1,807) Treasury Stock at Cost (Assume all Common) 1 (18,000) Total shareholders' equity 206,152 Total liabilities and shareholders' equity ### 147,782 $ 305,498 $ 247,750 $ 222,841 $ 208,642 National Beverage Corp. Annual Reports Statement of Cash Flows (Amounts in thousands) Fiscal Year Ended OPERATING ACTIVITIES: Net income 4/30/2016 $61,198 5/2/2015 $49,311 5/3/2014 $43,635 Adjustments to reconcile net income to net cash provided by (used in) operating activities: Depreciation and amortization Deferred income tax (benefit) provision Loss (gain) on disposal of property, net Stock-based compensation Changes in assets and liabilities: Trade receivables Inventories Prepaid and other assets Accounts payable Accrued and other liabilities Net cash provided by operating activities $ 12,056 $ (1,299) 129 228 (1,095) (4,998) (485) 4,495 8,726 $78,955 11,580 $ 1,076 (1,188) 307 (1,746) 990 (605) (710) (995) $58,020 11,708 79 51 95 5,864 (4,680) (2,548) 1,345 (3,167) $52,382 INVESTING ACTIVITIES: Net Additions to property, plant and equipment $ (12,024) $ (9,725) $ (12,062) Net cash used in investing activities $ (12,024) $ (9,725) $ (12,062) FINANCING ACTIVITIES: Dividends paid on common stock Dividends paid on preferred stock Repayments under credit facilities, net Redemption of preferred stock Proceeds from stock options exercised (186) (10,000) (6,000) 848 (239) (20,000) ### 228 (659) (20,000) (8,000) 47 Stock-based tax benefits Other 1,528 240 17 (60) Net cash used in financing activities $ (13,810) $ (25,771) $ (28,655) NET INCREASE IN CASH AND EQUIVALENTS CASH AND EQUIVALENTSBEGINNING OF YEAR $ 53,121 $ 52,456 22,524 $ 29,932 11,665 18,267 CASH AND EQUIVALENTSEND OF YEAR $ 105,577 $ 52,456 $ 29,932 OTHER CASH FLOW INFORMATION: Interest paid Income taxes paid $ $ 116 $ 29,473 $ 380 $ 24,745 $ 723 23,079 4/27/2013 $46,920 $ 11,002 172 63 230 (2,478) 1,628 (2,466) (10,614) (4,193) $40,264 $ (9,616) $ (9,616) (118,139) (12) 50,000 19,704 239 201 $ (48,007) $ (17,359) 35,626 $ 18,267 $ $ 341 24,327 Liquidity Ratios Calculate the Ratios Below: Fiscal Year Ended Current ratio Working capital Acid-test ratio Inventory turnover (times) Days sales in inventory Accounts receivable turnover (times) Days sales in receivables Free cash flow 4/30/2016 5/2/2015 5/3/2014 Average inventory Average A/R Explain the Ratios in separate Word Document that you will prepare as stated in "1-In (See "Example Analysis" for help on how to write this caption) 4/27/2013 2.06 The answer is here as an example to show you how I want each ceil to be filled in so it will prove your work are as stated in "1-Instructions Tab" Need to fill in these blanks with the ratio calculations required Be sure to show your work in each cell DO NOT CHANGE THE FORMATTING calculations required ANGE THE FORMATTING OF ANY CELL Incorrect Ratios Total Ratios This Page 0 34 Assessment Points 10 Solvency Ratios Calculate the Ratios Below: Fiscal Year Ended 4/30/2016 5/2/2015 Debt to equity Interest coverage Long term liabilities Explain the Ratios in separate Word Document that you will prepare as stated in "1 (See "Example Analysis" for help on how to write this caption) 5/3/2014 4/27/2013 ill prepare as stated in "1-Instructions Tab" Need to fill in these blanks with the ratio callculatio Be sure to show your work in each cell either cell r DO NOT CHANGE THE F with the ratio callculations required n each cell either cell references or numbers used O NOT CHANGE THE FORMATTING OF ANY CELL Incorrect Ratios Total Ratios This Page Assessment Points 0 12 10 Profitability Ratios Calculate the Ratios Below: Fiscal Year Ended 4/30/2016 5/2/2015 5/3/2014 Asset turnover Return on sales Gross margin % Return on assets Return on equity Average interest rate Average total assets Interest Net Income tax rate 1 - Income tax rate Net of tax interest expense Net of tax interest expense Net Earnings Adjusted net income Average equity Average total liabilities Explain the Ratios in separate Word Document that you will prepare as stated in "1-In (See "Example Analysis" for help on how to write this caption) 4/27/2013 Inc Tax / Pre Tax Earnings Calculate (1 - Inc Tx Rate) x Interest-Net Bring Down from Prior Row Net Earnings + Net of Tax Interest Expense as stated in "1-Instructions Tab" Need to fill in these blanks w Be sure to show your work Incorrect Ratios Total Ratios This Page 0 57 Assessment Points 10 Need to fill in these blanks with the ratio calculations required Be sure to show your work in each cell either cell references or numbers used DO NOT CHANGE THE FORMATTING OF ANY CELL DuPont Analysis of ROA Calculate the Ratios Below: Fiscal Year Ended 4/30/2016 Return on assets (calculated) X Return on sales Asset turnover = Product (Your calculated product should equa the return on assets calculated above Explain below the DuPont Therory (Use no less than 200 words) Include in your answer why the product calculated above should e 5/2/2015 5/3/2014 Need to fill in these blanks with the ratio calculations require Be sure to show your work in each cell either cell references DO NOT CHANGE THE FORMATT ur calculated product should equal return on assets calculated above) oduct calculated above should equal the first calculation return on assets tio calculations required l either cell references or numbers used HANGE THE FORMATTING OF ANY CELL Incorrect Ratios Total Ratios This Page Assessment Points his Page 0 3 10 Stock Ratios Calculate the Ratios Below: Fiscal Year Ended 4/30/2016 5/2/2015 Book value per common share Earnings per share (basic) Earnings per share (diluted) P/E Ratio Dividend yield Dividend payout Book value relating to common shares equity Common shares outstanding (thousands) Adjusted closing price Dividends per share Explain the Ratios in separate Word Document that you will prepare as stated in "1 (See "Example Analysis" for help on how to write this caption) 5/3/2014 4/27/2013 Need to fill in these blanks with the ratio calculations requir Be sure to show your work in each cell either cell reference DO NOT CHANGE THE FORMATT (Total Shareholders' Equity less: Preferred Stockholders' Equity) prepare as stated in "1-Instructions Tab" tio calculations required l either cell references or numbers used HANGE THE FORMATTING OF ANY CELL Incorrect Ratios Total Ratios This Page Assessment Points 0 40 10 Perform a both a vertical and horizontal analysis of the company's income statements and you to use for your horizonal analysis) To be done in the Word Document that you will pre In performing this vertical and horizontal analysis, consider any notable trends or changes Also use as many statements as you feel are necessary. You can compare between years o Word Document. Use as many analyses as necessary to show a good picture of the compa You should write a minimum of 500 words in this area. Explain the Ratios in separate Word Document that you will prepare as stated in "1-In both a vertical and horizontal analysis of the company's income statements and balance sheets. (I have pre for your horizonal analysis) To be done in the Word Document that you will prepare ming this vertical and horizontal analysis, consider any notable trends or changes that you observe that may s many statements as you feel are necessary. You can compare between years or use all the years to show ument. Use as many analyses as necessary to show a good picture of the company. d write a minimum of 500 words in this area. Income Statement (Amounts in thousands except per share data) Fiscal Year Ended Net sales Cost of sales Gross profit Expenses: Selling, general and administrative Other operating expense (income)net Interest expense Total Expenses Income before income taxes Provision for income taxes Net income Balance Sheet Balance Sheet (Amounts in thousands) Fiscal Year Ended ASSETS Current assets: Cash and equivalents Trade receivablesnet Inventories Deferred income taxesnet Prepaid and other assets Total current assets Property, plant and equipmentnet Goodwill Intangible assets Other assets Total assets LIABILITIES AND SHAREHOLDERS EQUITY Current liabilities: Accounts payable Accrued liabilities Income taxes payable Total current liabilities Long Term Notes Payable Deferred income taxes - net Other liabilities Total liabilties Shareholders' equity: Preferred Stock Common Stock Additional Paid in Capital (Assume all Common) 1 Retained Earnings Accumulated other comprehensive income (loss) Treasury Stock at Cost (Assume all Common) 1 Total shareholders' equity Total liabilities and shareholders' equity os in separate Word Document that you will prepare as stated in "1-Instructions Tab" nts and balance sheets. (I have prepared the vertical ananysis information relating to the financial stateme will prepare changes that you observe that may provide useful information concerning its financial condition. years or use all the years to show the trend you are trying to explain. You should write up your results in p company. 4/30/2016 $ $ $ 704,785 463,348 241,437 % 100.00% 65.74% 34.26% 148,384 145 203 148,732 92,705 31,507 61,198 21.05% 0.02% 0.03% 21.10% 13.15% 4.47% 8.68% 5/2/2015 $ $ 5/3/2014 $ 645,825 426,685 219,140 % 100.00% 66.07% 33.93% 145,157 (1,101) 371 144,427 74,713 25,402 49,311 22.48% -0.17% 0.06% 22.36% 11.57% 3.93% 7.64% $ $ $ 641,135 423,480 217,655 153,220 666 660 154,546 63,109 19,474 43,635 4/30/2016 5/2/2015 5/3/2014 $ % $ % $ $ 105,577 61,046 47,922 4,454 4,672 223,671 34.56% $ 19.98% 15.69% 1.46% 1.53% 73.22% $ 52,456 59,951 42,924 4,348 8,050 167,729 21.17% $ 24.20% 17.33% 1.75% 3.25% 67.70% $ 29,932 58,205 43,914 2,685 8,405 143,141 20.27% 4.30% 0.53% 1.68% 60,182 13,145 1,615 5,079 247,750 24.29% 5.31% 0.65% 2.05% $ 61,932 13,145 1,615 5,135 305,498 59,494 13,145 1,615 5,446 222,841 16.17% 8.57% 0.01% 0.00% $ 49,391 26,195 28 75,614 0.00% 4.74% 0.00% 3.03% $ 14,474 9,258 99,346 150 506 34,570 190,733 (1,807) $ $ 100.00% $ 100.00% $ 44,896 21,257 98 66,251 18.12% 8.58% 0.04% 0.00% 4.04% 6.15% 0.00% 3.42% 32.52% $ 10,000 15,245 8,472 99,968 40.35% $ 30,000 13,873 8,244 116,640 0.05% $ 0.17% 11.32% 62.43% -0.59% 270 504 37,759 129,773 (2,524) 0.11% $ 0.20% 15.24% 52.38% -1.02% 390 504 42,775 80,737 (205) 24.75% $ 26.74% $ 45,606 18,873 44 64,523 $ (18,000) 206,152 $ 305,498 n "1-Instructions Tab" -5.89% 67.48% $ 100.00% $ (18,000) 147,782 247,750 -7.27% 59.65% $ 100.00% $ (18,000) 106,201 222,841 g to the financial statements presented below for Incorrect Ratios Total Ratios This Page cial condition. Assessment Points write up your results in paragraph form in your 5/3/2014 4/27/2013 % 100.00% 66.05% 33.95% 23.90% 0.10% 0.10% 24.11% 9.84% 3.04% 6.81% $ $ $ 662,007 444,757 217,250 % 100.00% 67.18% 32.82% 146,223 173 403 146,799 70,451 23,531 46,920 22.09% 0.03% 0.06% 22.17% 10.64% 3.55% 7.09% 5/3/2014 4/27/2013 % $ % 13.43% $ 26.12% 19.71% 1.20% 3.77% 64.23% $ 18,267 64,069 39,234 3,665 5,706 130,941 8.76% 30.71% 18.80% 1.76% 2.73% 26.70% 5.90% 0.72% 2.44% 57,307 13,145 1,615 5,634 208,642 27.47% 6.30% 0.77% 2.70% 100.00% $ 20.47% 8.47% 0.02% 0.00% 28.95% $ 13.46% 6.23% 0.00% 3.70% 52.34% $ 0.18% $ 0.23% 19.20% 36.23% -0.09% 62.76% 100.00% 44,261 19,142 34 63,437 21.21% 9.17% 0.02% 0.00% 50,000 14,327 10,562 138,326 23.96% 6.87% 0.00% 5.06% 550 504 50,398 37,828 (964) 30.40% 66.30% 0.26% 0.24% 24.16% 18.13% -0.46% -8.08% 47.66% $ 100.00% $ (18,000) 70,316 208,642 -8.63% 33.70% 100.00% 0 0 10