Create an excel financial model
Budget: $30 – $250 USD
I am looking for someone to create an excel financial model for my online furniture store. The ideal candidate should have experience in financial modeling and be proficient in excel. Please use the images provided as a template and have them under seperate tabs.
Specific requirements for the project include:
- The model should include an income statement, balance sheet, and cash flow statement.
- The forecast period for the financial model should be 4-6 years.
- The financial model should include both a high-level summary and a detailed breakdown of the financial metrics.
Key Input
Advertising Budget – Input is linked to Sales, the more you spend on the advertisement, the more sales you’ll generate.
The growth rate of Visitors- at what rate are your visitors coming to your website?
Refund Rate – at what rate your sold products return by customers?
Percentage of Converted Repeat Customers – At what percentage of new total customers come to your store repeatedly?
Average Payable and Receivable days, which your business is following.
Cost of Good Sold Percentage of each Product.
Inventory Rate
Average Price of each product category.
Tax Rate
Skills and experience required:
- Strong proficiency in excel and financial modeling.
- Knowledge of financial statements and forecasting.
- Attention to detail and ability to create accurate and comprehensive financial models.
If you have previous experience in creating excel financial models and are confident in your ability to meet these requirements, please submit your proposal.
Specific requirements for the project include:
- The model should include an income statement, balance sheet, and cash flow statement.
- The forecast period for the financial model should be 4-6 years.
- The financial model should include both a high-level summary and a detailed breakdown of the financial metrics.
Key Input
Advertising Budget – Input is linked to Sales, the more you spend on the advertisement, the more sales you’ll generate.
The growth rate of Visitors- at what rate are your visitors coming to your website?
Refund Rate – at what rate your sold products return by customers?
Percentage of Converted Repeat Customers – At what percentage of new total customers come to your store repeatedly?
Average Payable and Receivable days, which your business is following.
Cost of Good Sold Percentage of each Product.
Inventory Rate
Average Price of each product category.
Tax Rate
Skills and experience required:
- Strong proficiency in excel and financial modeling.
- Knowledge of financial statements and forecasting.
- Attention to detail and ability to create accurate and comprehensive financial models.
If you have previous experience in creating excel financial models and are confident in your ability to meet these requirements, please submit your proposal.