Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
  • Financial Excel Model
Originally published: 09/04/2019 15:58
Last version published: 23/04/2019 16:44
Publication number: ELQ-77740-3
View all versions & Certificate
certified

Financial Excel Model

A 7 tab Spreadsheet Financial Model in Excel to make financial projections for a operating SPV.

Description
This excel financial model has been developed for the purpose of making some SPV's financial projections based on its historic financial data and other user's assumptions. It also calculates debt coverage ratios, profitability, liquidity and leverage ratios that are required in the process of assessing the company's viability and returns.

The model consists of the following parts/worksheets:
1) Cover sheet
2) Info sheet
3) Historic Data sheet
4) TI_Inputs sheet, which refers to the time-independent inputs (model's parameters/assumptions) that are required to be inserted by the user
5) TD_Inputs sheet, which refers to the time-dependent inputs that are required to be inserted by the user
6) Debt Amortization sheet which includes the scheduled debt repayment for all long-term loan facilities (pre-cash sweep effect)
7) Calculations sheet which includes the projected annual financial statements, ratios and results

The users of this model use it entirely at their own risk and no responsibility is taken or accepted by the developer for any losses which may result therefrom. The financial projections do not constitute a profit forecast, but illustrate the possible results if the assumptions adopted in this Model were to be correct. The financial results may be materially affected by changes in economy or other circumstances.

This business tool includes
1 Excel File

Dimitris Kourpatsos offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

  • Amminergy(last updated: 13/08/2019 19:49)
  • Marcos Romo(last updated: 02/08/2019 15:15)
  • Dr.mohamed Sururr(last updated: 08/07/2019 09:32)
  • Bahram Fozouni(last updated: 07/07/2019 11:23)
  • Siyabulela Makaula(last updated: 05/07/2019 10:04)
  • Kim Jichang(last updated: 15/05/2019 04:31)
  • Desmond Agboifo(last updated: 03/05/2019 13:24)
    Great
    Excellent Model.
  • Amir Ganic(last updated: 13/04/2019 14:41)
    Nice work...well structured
    One question...if we change basic element od LT such as Interest period or Type of Interest than we have Error Checks in Positiv Error Checks ..in Fin Calc Sheets...

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Financial Excel Model?

The user community and author are here to help. Go ahead!

please wait...