Need an Excel/Google Sheets Expert to edit my current financial model for payday loan business -- 3
Budget: $30 – $250 AUD
I am looking for an Excel/Google Sheets expert to edit my current financial model for my payday loan business. The specific changes that I need in the financial model include updating expense and revenue projections. I also need help in validating the accuracy of the financial model. The edited financial model should be in Google Sheets format.
Ideal skills and experience for this job include:
- Expertise in Excel/Google Sheets
- Knowledge of financial modeling for payday loan businesses
- Ability to update expense and revenue projections accurately
- Experience in validating the accuracy of financial models
- Proficiency in Google Sheets formatting and functions.
We need adjustments to the sheet to showcase the following;
- I want to be able to add where I can add 'Average term of loan' and add in the months I wish the average loan to be
- currently our 'Default' % rate of the amount of payments due that don't get paid each week I don't believe is changing the cashflow for negative or positive
- Want to showcase a line item in the monthly summary of total default fees earns at the default fee rate
- Also we wish to sell our bad debt, so I want the ability to put a % amount of earned back capital for bad debt we sell at the bottom line
Link to sheet: https://docs.google.com/spreadsheets/d/11C5vLlslDnG7nM6b_eatcEyVgo8ErZnfD7_7tPHGMN4/edit?usp=sharing
Please do not enquire before checking the sheet! Write code word FASTER when applying
Ideal skills and experience for this job include:
- Expertise in Excel/Google Sheets
- Knowledge of financial modeling for payday loan businesses
- Ability to update expense and revenue projections accurately
- Experience in validating the accuracy of financial models
- Proficiency in Google Sheets formatting and functions.
We need adjustments to the sheet to showcase the following;
- I want to be able to add where I can add 'Average term of loan' and add in the months I wish the average loan to be
- currently our 'Default' % rate of the amount of payments due that don't get paid each week I don't believe is changing the cashflow for negative or positive
- Want to showcase a line item in the monthly summary of total default fees earns at the default fee rate
- Also we wish to sell our bad debt, so I want the ability to put a % amount of earned back capital for bad debt we sell at the bottom line
Link to sheet: https://docs.google.com/spreadsheets/d/11C5vLlslDnG7nM6b_eatcEyVgo8ErZnfD7_7tPHGMN4/edit?usp=sharing
Please do not enquire before checking the sheet! Write code word FASTER when applying