Statistics for Accountants in Excel

Summary

Statistics for Accountants in Excel looks at the various ways you can use statistics and probability to enhance your role as an accounting and finance professional.

This course is provided by a third party provider accountingcpd.net and the fee charged is exclusive of VAT. 

Venue details:  
Online EU, ,
Start date & time:  
01 January 2019 00:00
End date & time:  
01 January 2022 00:00
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.50 Training Tickets accepted
CPD hours:  
4.00
Speaker details
First nameLast name
AccountingCPD. net

Description

Product type:  
CPD online course
Category:  
AccountingCPD.net, Financial reporting

Booking with a Training Ticket

Once you have booked your course, you will receive an email with your booking confirmation. The steps you will need to follow to access your online course will arrive in a separate email within 48 hours of your order being processed

Please be aware that participants will have access to this course for 120 days from the date of receiving access via email notification

Course Overview

This course will enable you to incorporate financing issues and their implications into your model. It also provides the tools to help you use financial models to assess investment options, for example, when comparing projects with different investments and levels of certainty on expected returns.

Modelling capital expenditure

  • What is capital expenditure?
  • What is required to calculate the capital expenditure requirement?
  • How is the calculation block for the capital expenditure constructed?
  • What real-life factors might need to be considered?

Financing options

  • What do we mean by financing?
  • Why do businesses seek finance?
  • What is the finance likely to be used for?
  • From what sources might finance be obtained?
  • Where in the model should the funding calculations be placed?
  • How accurately do the cash flows associated with the funding need to be predicted?

Funding from internal or external sources

  • Why and when might funding be sought from internal or external sources?
  • What is "circularity" in a financial model?
  • Which ingredients are required to calculate the funding requirement?
  • How do I build a calculation to show the loan balance?
  • What is the structure of the calculation block loan interest?
  • What is the structure of the calculation block for the loan repayments?

Time value of money

  • What is time value of money?
  • What is the importance of time value of money in relation to different financing options?
  • Which ingredients are required to calculate the discounted cash flow?
  • What is the structure of the calculation block for the discounted cash flow?
  • What other methods are used to compare cash flows?