I am unsure how to start this and how to fill out excel. Please help, question below.
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/666cc9f5d5955_621666cc9f5d1f39.jpg)
I am unsure how to start this and how to fill out excel. Please help, question below.
Question:Part 1-Excel Sheet Prepare Ratios
Ratios for National Beverage Corp. concerning liquidity, solvency, profitability, DuPont, and stock performance as of April 30, 2016 and prior statement information. For each area, you should calculate the ratios we discussed in class and provide an analysis of the ratios calculated.I include historical stock price information and outstanding common share information below.
Part 2 -Separate Word Document Analyses
Word Analyses Document with the following headings and prepare you analyses like that shown in "Example Analysis" (See Black Tab labeled Example Analysis) below for 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 already have been analyzed with theProfitability Ratios
Therefore I want you toExplain the DuPont Theory with a minimum of two hundred wordsto prove you understand what theDuPont Theory is all about
5.Stock Ratios Analyses
6.Vertical and Horizontal Analyses
1.Explain why not all the Fiscal Years Ended listed for National Beverage below do not fall on the last day of April.
2.For the Vertical and Horizontal Analyses only, explain several notable Ratios (you do not have to explain all of them)that have the most meaning to prove the analysis you are trying to make about the company.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/666cc9f614f89_622666cc9f611041.jpg)