Booking Information
Once you have booked your course, you will receive a confirmation email containing an access link and passcode. Use these to set up your account on the Chartered Accountants Ireland Portal within the Kubicle sitesite.
About this course
You can use Excel to help build financial projections for your company’s future. In this course, you’ll learn what information you need to gather, and how to analyze it. Across 13 lessons, you’ll see how working with your existing financial statements can help in building projections and how financial modelling can be applied. By the end of the course, you should have a greater understanding of how to use Excel to mine your data for patterns that can help predict future outcomes.
Learning Outcomes
- Explain the purpose of creating financial projections
- Create assumptions and projections for an Income Statement
- Calculate projections for capital expenditure and depreciation
- Create assumptions and projections for a Balance Sheet
- Create assumptions and projections for a Statement of Cash Flows
- Adjust projections and maintain a balanced model
Lessons
- Why Build Financial Projections?
- Structuring Projections in Excel
- Creating Income Statement Assumption
- Building Projections for the Income Statement
- Capital Expenditure and Depreciation
- Creating Balance Sheet Assumptions Part 1
- Creating Balance Sheet Assumptions Part 2
- Building Projections for the Balance Sheet
- Completing Balance Sheet Projections
- Projecting Operating Cashflows
- Completing Our Financial Projections
- Keeping the Model Balanced
- Reviewing Financial Projections
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
Contact us
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930
Note for Legacy CPA Members
Members who joined Chartered Accountants Ireland following1 September 2024, please continue to book on the CPA Portal here to ensure you receive your member discount.
LOADING...