Build me an Excel Template

Job ID: 35461897

Budget: $30 – $250 USD

Goal is to raise 10 million in loans by December 31, 2023.

I need a spreadsheet that tracks amount and percentage lended out. I need to know how far behind or ahead we are in loans compared to the goal.. We need to loan $27,398 per day and I need to know daily how far behind or ahead of the goal we are Daily. Should change daily December 31, 2022 to December 31, 2023.

We have 6 Auto dealers we loan to, I need to track money loaned on this spreadsheet individually.

-Add a chart showing which dealerships amount loaned. They are in competition and want to see where they’re at on the chart.
-Add amount behind or ahead of loan schedule automatically changing everyday. Dollar numbers and percentage using $27,398 per day, every day of 2023.

Again, we loan money to 6 car dealers. We need to hit 10 million loaned out in 2023. Want to track by number and percentage daily.
Related categories: Excel Mathematics