Learn how to create spreadsheet models for cash flow, net present value (NPV) and pricing in this free online course. Have you ever undertaken a complex financial analysis that involved an iterative calculation process? In this free online Microsoft Excel tutorial, you will learn how to use the software to make such calculations easier and faster. You will study how to create MS Excel spreadsheet models to help compute a range of calculations for the purposes of financial management and comparisons of potential investment options for informed decision-making.
| College | Alison |
| Course ID | 201664 |
| Course Type | Online Learning |
| Course Qualification | CPD Certificate |
| Course Duration | 1.5-3 hours |
| Course Fee | Free |
| Entry Requirements | Like all courses on the Alison Free Learning platform this is a free, CPD-accredited course. A Graduate can choose to buy a certificate or diploma upon successful completion of a course, but this is not required or necessary. At Alison we believe that free education, more than anything, has the power to break through boundaries and transform lives. Alison is the world’s largest free online empowerment platform for education and skills training, offering over 5000 CPD accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone, to study anything, anywhere, at any time, for free online, at any subject level. Through our mission, we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone. |
| Career Path | What You Will Learn In This Free Course • List the key elements that should appear in every spreadsheet model • Outline the steps involved in getting ready to build a spreadsheet model • Summarize the factors that need to be considered when building the input datasheet for a pricing model • Select an appropriate discount rate for use in net present value analysis • State the risks that increase with the life of a project • Estimate the value of the project or business using the discounted cash flow valuation model |
| Course Code | 3995 |
Learn how to become a professional carpenter in this free online woodworking course that covers the basics of the craft.
This free online caregiving course explains how to provide palliative and end-of-life support to patients and families.
Explore new vocabulary and grammar associated with travel, health and goals in the second diploma course in Spanish.
Learn how modern transportation systems are causing the deterioration of the climate with this free online course.
