
DCF model in 6 hours Friday next week at 2PM to 8 PM GST time
- or -
Post a project like this788
£176(approx. $243)
- Posted:
- Proposals: 7
- Remote
- #4103991
- OPPORTUNITY
- Awarded
Graphic Designer |Experienced Web Designer | Video/Audio Editor | PowerPoint/Keynote | Content Writer |

UK Chartered Accountant (ACA)/ FCCA / IFRS and reporting specialist / Excel expert / Xero Advisor

62208329760463343141621385061018423686005837342628
Description
Experience Level: Expert
Please put together a one-page investment profile on the Company (as defined below) in PowerPoint format.
Please put together a simple three-statement financial model of the Company in Excel which should include the following:
Historical financial results of the Company for the last five years (2018-22)
Projections for all three statements of the model for the next five years (2023-27)
Valuation tab where you should calculate the fair share price of the Company by using DCF method and compare it with the current share price of the Company
Assumptions tab where you should describe the key inputs and assumptions behind your projections / valuation, including any macro, operational and other datasets
Your public Company for the above tasks is: Tesco plc.
All the information on the Company should be sourced from the public sources only and the relevant links for your historical data inputs and for any assumptions you use should be included in the excel file together with the model.
Please put together a simple three-statement financial model of the Company in Excel which should include the following:
Historical financial results of the Company for the last five years (2018-22)
Projections for all three statements of the model for the next five years (2023-27)
Valuation tab where you should calculate the fair share price of the Company by using DCF method and compare it with the current share price of the Company
Assumptions tab where you should describe the key inputs and assumptions behind your projections / valuation, including any macro, operational and other datasets
Your public Company for the above tasks is: Tesco plc.
All the information on the Company should be sourced from the public sources only and the relevant links for your historical data inputs and for any assumptions you use should be included in the excel file together with the model.
Emad A.
0% (0)Projects Completed
2
Freelancers worked with
2
Projects awarded
60%
Last project
4 Feb 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies