Current and historical Financial Statements (Income Statement (I/S), Balance Sheet (B/S) and Statement of Cash Flows) from
Question:
Current and historical Financial Statements (Income Statement (I/S), Balance Sheet (B/S) and Statement of Cash Flows) from the three most current years for the firm The financial statements must include changes (deltas) between years. Ratios from the most current and available three years with deltas and analysis Alternative strategies (giving advantages and alternatives for each) Pro-Forma Financial Statements (I/S, B/S and Statement of Cash Flows) with deltas out three years and analysis Each year must have two columns: one with your strategy and one without your strategy.Include Pro-Forma ratios for the first year out with deltas contrasting from the most current year?s ratios. Net Present Value analysis of proposed strategy?s new cash flow and EPS/EBIT analysis NOTE: To construct the first cash flow (cf1) at the very minimum, the new revenue from your strategy(s) must be discounted back to the present value by calculating EBIT and that figure will be your cfn for each year. cf0 (initial cost of your strategy), cf1 (discounted cash flow first year), r (opportunity cost of capital, the rate of the next best alternative use of cash/debt/equity resources). I guess I just want to ensure I understand what they are asking for. Attached is a document that I am using to get historical financial statements etc. I need help understanding how to get EBIT and NPV
Template Instructions 1. Read all instructions on the Template for detailed advice and tips. 2. Never type in a red area unless otherwise noted. Save frequent backup copies of this Template in case you do this by mistake. 3. If you have a problem viewing any of your text on a long sentence, select the problem cell and use the text wrap feature. It can be found under the \"home\" tab on Excel 2007. You may have to click wrap text twice (just a bug in Excel). 4. To get your matrices and charts into Excel or Power Point, highlight them and then copy and paste special into Word or Power Point. If you don't use paste special then it will not work properly. 5. Paste special will give you several options, be sure to use the \"MS Excel Worksheet Object\" Option. You must also check \"paste\" or \"paste link\" 6. The advantages of using the \"paste link\" option are as you change the data in Excel it will change in your Word or Power Point file provide both are open. This is a nice feature as if you decide to change some data, you don't have to paste special everything back over into Power Point or Word. 7. The advantage of just using \"paste\" option is your file is not linked to Excel. If something where to happen with Excel or MS Office wants to be temperamental on the day of your presentation, and you had checked the \"paste link\" option, then your data will not show on Word or Power Point. 8. You may also use a program called Jing, found at http://www.techsmith.com/jing.html to copy the matrices and save as jpeg files for later entry into Power Point. The program is free. Free Excel Student Template Dear Student, By using this Template, you hereby agree to the Copyright terms and conditions. This Template should save you considerable time and allow for your presentation to be more professional. Do not mistake this Template for doing all of the work. Your assignment is to analyze and present strategies for the next three years. You will still need to do the research and enter key internal and external information into the Template. The Template does not gather or prioritize information. It does however assimilate information you enter in a professional way and does many calculations for you once that critical information is entered. Best of luck, with your project. INSTRUCTIONS FOR TEMPLATE 1 Please read all Template instructions below carefully before you start each new section of this Template. Only type in the green boxes unless otherwise noted. Please read the Read ME tab at the bottom of Excel before you start. INSTRUCTIONS FOR EXTERNAL AUDIT