Understanding the Three Major Financial Statements Assignment

Assignment Task

Overview

Before we begin, let us take this opportunity to congratulate you on completing the course of Financial Management. This is definitely one of the most intense courses of your SSBM EMBA degree, and the same is going to be the case for the project as well. 

The project aims to test your knowledge as you apply your learnings from this course. 

The project requires you to download the financial statements, namely the Balance Sheet, Income Statement and , Cash Flow Statement of any company of your liking for the last three years .

Once you get the data, you are to add the data of the table to the excel sheet in the next slide. All the other details pertaining to the project are shared in the PDF document and Excel Sheet shared in the next segment.

Case Study

The objective of the project is to create an excel financial model associated with formulas from accounting to cash flow to Valuate the company, to calculate CF, FCF, optimal capital structure and to determine the risk of investment (CAPEX) using different techniques for measuring investment profitability. You will have a company with its financial forecasts in excel with a possibility to do scenario or sensitivity analysis.

Please find the Excel Sheet in which you are to perform the project below. Your submission needs to be the same excel sheet that you download. 

Note

Page 2, ie. sheet 2 of the excel sheet has blue areas wherein you can copy paste the data as required, or also take a screenshot of the various financial statements and paste them there

All the instructions necessary to solve the course have been given in the Excel Sheet and the PDF Document. Before you solve any of the excel sheets, make sure that you refer to the instructions in the PDF document on solving that particular sheet.

This Financial Management has been solved by our PhD Experts at My Uni Paper.