Assignment :
You have just been hired as CFO by company defined in P2 History sheet. Your first assignment is to Value the company based on historical values and projected
Cash Flows (CF's). To do this, your assignment is to create an excel financial model based on sheets P2 and P3 where you will have manually
added figures/tables and based on sheets P4 to P9 where you will have to add the calculations in requested fields with formulas.
Once completed all sheets from P1 to P9 you have to conclude based on obtained results : profitability of your investment, optimal capital structuire, Company value and associated risks
Objective:
The goal is to apply in practice the financial tools you have learned on FM lectures.
It is a specific task whose solution makes it possible to understand and manage corporate finance in any company.
Methodology :
Before you start this assignment it is important that you complete all lectures and case studies in excel from course FM.
Page 1 Tips is there to help you with some recommendations and suggestions in order to deliver your model as expected by your management.
To deliver efficiently the assignment you should start from historical figures from balance sheet, P&L and CF statement in P2.
In P3 you will add manually in cells in green color the main inputs that you need to project your future P&L and CF's, except in the cells that are pre-defined (already filled)
Then in P4 you will have to calculate the amortization of your asset which is necessary for your P&L.
In P5 you will be required to calculate the costs of your capital : loans, bonds, stocks and WACC which is necessary for discounting of your CF's.
This page will help to understand and explain the optimal capital structure.
Once you do all this, you can go in P6 where the P&L projection is to be done.
Based on your P&L projection and other balance sheet items you can do the P7 CF's projection.
Once you have your CF's you can do different scenarios (best case, base case and worst case) in P8.
In this page you will determine the risk of investment (CAPEX) using different techniques for measuring investment profitability.
In P9 you will have to determine you Net Working Capital which is important to know in case of liquidity problems and need for short term company financing.
In P10 you are requested to do the Valuation of your company, consequently to calculate the Equity value and stock price.
At end, in P11 you have to conclude all and bring conclusion and recommendations based on obtained results from pages 2-10.
Instructor will give the comments and grade based on all sheets in P12.
Assignment :
You have just been hired as CFO by company defined in P2 History sheet. Your first assignment is to Value the company based on historical values and projected
Cash Flows (CF's). To do this, your assignment is to create an excel financial model based on sheets P2 and P3 where you will have manually
added figures/tables and based on sheets P4 to P9 where you will have to add the calculations in requested fields with formulas.
Once completed all sheets from P1 to P9 you have to conclude based on obtained results : profitability of your investment, optimal capital structuire, Company value and associated risks
Objective:
The goal is to apply in practice the financial tools you have learned on FM lectures.
It is a specific task whose solution makes it possible to understand and manage corporate finance in any company.
Methodology :
Before you start this assignment it is important that you complete all lectures and case studies in excel from course FM.
Page 1 Tips is there to help you with some recommendations and suggestions in order to deliver your model as expected by your management.
To deliver efficiently the assignment you should start from historical figures from balance sheet, P&L and CF statement in P2.
In P3 you will add manually in cells in green color the main inputs that you need to project your future P&L and CF's, except in the cells that are pre-defined (already filled)
Then in P4 you will have to calculate the amortization of your asset which is necessary for your P&L.
In P5 you will be required to calculate the costs of your capital : loans, bonds, stocks and WACC which is necessary for discounting of your CF's.
This page will help to understand and explain the optimal capital structure.
Once you do all this, you can go in P6 where the P&L projection is to be done.
Based on your P&L projection and other balance sheet items you can do the P7 CF's projection.
Once you have your CF's you can do different scenarios (best case, base case and worst case) in P8.
In this page you will determine the risk of investment (CAPEX) using different techniques for measuring investment profitability.
In P9 you will have to determine you Net Working Capital which is important to know in case of liquidity problems and need for short term company financing.
In P10 you are requested to do the Valuation of your company, consequently to calculate the Equity value and stock price.
At end, in P11 you have to conclude all and bring conclusion and recommendations based on obtained results from pages 2-10.
Instructor will give the comments and grade based on all sheets in P12.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
