Create Model in Excel Detailing Month by Month Forecasting
Budget: $10 – $30 USD
With the Point-of-Sale program launching in Q1 2022, annual origination volume is expected to increase more than 30X over the next 12 months.
Current Conditions:
• Sales Team Members= 4
• Merchants = 100
• Borrower Accounts = 1,600
Forecasted/future Conditions:
• Sales Team Members = 30
o Each sales rep is expected to onboard on 20 merchants per month
o Each merchant is expected to do $25,000/month
• Merchants = 6,000 (assume non-linear ramp from current count)
• Borrower Accounts =40,000 (assume non-linear ramp from current count)
Given the current and forecasted conditions, please create a model in excel detailing the month by month forecast of sales revenue we can expect for the remainder of 2022. Please be sure to include seasonality and industry trends (Healthcare, Retail, Home Improvement) in your forecast. Please be prepared to explain how you arrived at your numbers.
Current Conditions:
• Sales Team Members= 4
• Merchants = 100
• Borrower Accounts = 1,600
Forecasted/future Conditions:
• Sales Team Members = 30
o Each sales rep is expected to onboard on 20 merchants per month
o Each merchant is expected to do $25,000/month
• Merchants = 6,000 (assume non-linear ramp from current count)
• Borrower Accounts =40,000 (assume non-linear ramp from current count)
Given the current and forecasted conditions, please create a model in excel detailing the month by month forecast of sales revenue we can expect for the remainder of 2022. Please be sure to include seasonality and industry trends (Healthcare, Retail, Home Improvement) in your forecast. Please be prepared to explain how you arrived at your numbers.
Related categories:
Excel
Business Analysis
Financial Analysis
Financial Forecasting
Budgeting and Forecasting