Build a 3-Way Forecast/Statement Model in Excel
- or -
Post a project like this403
£160(approx. $201)
- Posted:
- Proposals: 19
- Remote
- #3862234
- OPPORTUNITY
- PRE-FUNDED
- Awarded
Chartered Certified Accountant (ACCA) / IFRS and reporting specialist / Excel expert / Xero Advisor / Book keeper
Yanbu` al Bahr
21385065484125887694486509718599570854343281956167814187716973464035075880152302511
Description
Experience Level: Expert
Estimated project duration: less than 1 week
I need the attached hard copy financial statements turned into an Excel 3-way forecast/statement model (integrated income statement, balance sheet and cash flow statement) to present to a financier as part of a finance application for a business acquisition fin Australia.
The deliverable excel model must reconcile to the attached financial statements and allow me to easily change input variables for future forecasts.
Attached is a sample 3-way model that I started completing for the P&L/Income statement, yet am facing a learning curve that I do not presently have time to resolve when it comes to the balance sheet and cash flow statement modelling.
I do not mind if you keep building out the attached excel model or utilise a model you prefer or have successfully used in the past - so long as the model is accurate and dynamic between the 3 statements when key variables are changed.
The attached hard copy statements are all I have to work with - i.e. I do not have the ability to provide further clarification, data or info beyond what is attached. However, I will of course be on hand to support with any commercial or model design/feature queries that you may have.
Key points:
- Forecast 2023 EBITDA equal to $6.0M
- Historic actuals to start from 2018 so as to show 3-years trailing adjusting for 2020/2021 covid disrupted years
- 5-year forecast starting 2023
- Include two debt facilities to be amortised by end of 2026 and 2028 financial years respectively:
--- debt facility 1 = $8.0M at 6.25% interest per annum with 5 year maturity (2028 terminal repayment)
--- debt facility 2 = $5.0M at 10% interest per annum with 3 year maturity (2026 terminal repayment)
- The model is to be presented to an Australian bank
- Would be good if there is a separate tab for simple business valuation modelling
- Finished model needs to be presented in a simple to navigate and read format and styling
I ideally need this completed by Wednesday evening, yet can stretch to the weekend right person.
Thank you!
The deliverable excel model must reconcile to the attached financial statements and allow me to easily change input variables for future forecasts.
Attached is a sample 3-way model that I started completing for the P&L/Income statement, yet am facing a learning curve that I do not presently have time to resolve when it comes to the balance sheet and cash flow statement modelling.
I do not mind if you keep building out the attached excel model or utilise a model you prefer or have successfully used in the past - so long as the model is accurate and dynamic between the 3 statements when key variables are changed.
The attached hard copy statements are all I have to work with - i.e. I do not have the ability to provide further clarification, data or info beyond what is attached. However, I will of course be on hand to support with any commercial or model design/feature queries that you may have.
Key points:
- Forecast 2023 EBITDA equal to $6.0M
- Historic actuals to start from 2018 so as to show 3-years trailing adjusting for 2020/2021 covid disrupted years
- 5-year forecast starting 2023
- Include two debt facilities to be amortised by end of 2026 and 2028 financial years respectively:
--- debt facility 1 = $8.0M at 6.25% interest per annum with 5 year maturity (2028 terminal repayment)
--- debt facility 2 = $5.0M at 10% interest per annum with 3 year maturity (2026 terminal repayment)
- The model is to be presented to an Australian bank
- Would be good if there is a separate tab for simple business valuation modelling
- Finished model needs to be presented in a simple to navigate and read format and styling
I ideally need this completed by Wednesday evening, yet can stretch to the weekend right person.
Thank you!
Ryan J.
100% (4)Projects Completed
5
Freelancers worked with
3
Projects awarded
100%
Last project
1 Aug 2023
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