logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Rakesh GillComputer science
(5/5)

922 Answers

Hire Me
expert
Zuber KhanEconomics
(5/5)

519 Answers

Hire Me
expert
Rob RouseData mining
(5/5)

688 Answers

Hire Me
expert
Blake BarnesEngineering
(5/5)

913 Answers

Hire Me
Microsoft Excel
(5/5)

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

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

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.

 

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

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

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

448 Experts Online