Prepare DCF model on Pepsico -- 2
Budget: ₹600 – ₹1,500 INR
Please create a Financial Model for PepsiCo
Please include at least 2 historical years with quarters “(Q1 2019 – Q2 2022) and forecast quarterly Q3 2022 -Q4 2022 and annual for FY 2023 & FY 2024”. Forecasts should be included in all the 3 financials statements (IS, BS and CF).
Use this forecast and derive the intrinsic value applying DCF Valuation
Please ensure, model is clean, easy to scan and dynamic i.e. we can change forecast assumptions to see the effect on the intrinsic value.
Keep it short/simple but highlight your sources clearly
Explain your assumptions in brief (add comment in respective cells) used to forecast financials
Write-up
Please create a short Company Profile for PepsiCo, highlight its investment strength and weakness, and a short commentary on the latest earnings results. Keep your views short and brief.
Please use publicly available information only and ensure that the content is not plagiarized.
Please include at least 2 historical years with quarters “(Q1 2019 – Q2 2022) and forecast quarterly Q3 2022 -Q4 2022 and annual for FY 2023 & FY 2024”. Forecasts should be included in all the 3 financials statements (IS, BS and CF).
Use this forecast and derive the intrinsic value applying DCF Valuation
Please ensure, model is clean, easy to scan and dynamic i.e. we can change forecast assumptions to see the effect on the intrinsic value.
Keep it short/simple but highlight your sources clearly
Explain your assumptions in brief (add comment in respective cells) used to forecast financials
Write-up
Please create a short Company Profile for PepsiCo, highlight its investment strength and weakness, and a short commentary on the latest earnings results. Keep your views short and brief.
Please use publicly available information only and ensure that the content is not plagiarized.