Skip to content

About

I have created a 3-statement financial model in Excel. Here you will see how to structure fixed assets roll-forward, financial liabilities, and equity schedules and link them to the Income Statement, Balance Sheet, and Cash Flow Statement. PLEASE NOTE that I have uploaded files with serial number. I hope this will help you all.

Topics

accountingcashflow-analysisdata-analysisexcelfinancial-analysisfinancial-modelling
Activity

Stars

4 stars

Watchers

1 watching

Forks

2 forks
Report repository
BranchesTags

Latest commit

 

History

1 Commit

Folders and files

NameName
Last commit message
Last commit date
Adding Forecast 8.xlsx
Adding Forecast 8.xlsx
 
 
Building Balance Sheet 6.xlsx
Building Balance Sheet 6.xlsx
 
 
Building Equity schedule 16.xlsx
Building Equity schedule 16.xlsx
 
 
Building Financial Liabilities schedule 15.xlsx
Building Financial Liabilities schedule 15.xlsx
 
 
Building Fixed asset Schedule 14.xlsx
Building Fixed asset Schedule 14.xlsx
 
 
Calculating DPO,DSO,DIO_12.xlsx
Calculating DPO,DSO,DIO_12.xlsx
 
 
Calculating Historical Perc ratio_9.xlsx
Calculating Historical Perc ratio_9.xlsx
 
 
Calculation Per Variance 5.xlsx
Calculation Per Variance 5.xlsx
 
 
Choose&Match_10.xlsx
Choose&Match_10.xlsx
 
 
Forecasting DPO,DSO,DIO_13.xlsx
Forecasting DPO,DSO,DIO_13.xlsx
 
 
Introduction to exercise_1.xlsx
Introduction to exercise_1.xlsx
 
 
Mapping of Financial 2.xlsx
Mapping of Financial 2.xlsx
 
 
Output P&L sheet 3.xlsx
Output P&L sheet 3.xlsx
 
 
Preparing cash flow 17.xlsx
Preparing cash flow 17.xlsx
 
 
Preparing cash flow and completing the model.xlsx
Preparing cash flow and completing the model.xlsx
 
 
Using Index to fill 7.xlsx
Using Index to fill 7.xlsx
 
 
Vlookup&Column_11.xlsx
Vlookup&Column_11.xlsx
 
 
filling P&L with history fin 4.xlsx
filling P&L with history fin 4.xlsx
 
 

About

I have created a 3-statement financial model in Excel. Here you will see how to structure fixed assets roll-forward, financial liabilities, and equity schedules and link them to the Income Statement, Balance Sheet, and Cash Flow Statement. PLEASE NOTE that I have uploaded files with serial number. I hope this will help you all.

Topics

accountingcashflow-analysisdata-analysisexcelfinancial-analysisfinancial-modelling
Activity

Stars

4 stars

Watchers

1 watching

Forks

2 forks
Report repository

Releases

Packages

Contributors