Trying to calculate future profit based on profit to current date

**fandiwany** · 01-08-2023, 11:14 AM

I'm trying to work out the potential balance based on the current rate of revenue

Start date 1 Nov 2022
Today's date 8 Jan 2023
Business days so far 68
Starting Capital $5000
Balance as of today $18000

Est. earnings after 1 years TOTAL

I tried working out the average % increase per 30 days and then compound that 12 times to get projected annual revenue, but the figure was way off. I've tried adapting so many different formulas for compound interest that I found online, but none of them are giving me what I want. Is anyone able to assist?

**MrShorty** · 01-08-2023, 02:38 PM

What financial model are you wanting to use for this? What result are you expecting? Before we can answer the Excel programming side of a question like this, it seems to me that we must first get a solid handle on the math and finance principles that you want to use for this forecast.

If you are uncertain of the financial model you want to use, rounding numbers to something I can do in my head (starting value=5000, value after 2 months=15000) what I am seeing is an investment that roughly triples every 2 months. Something that triples in value every 2 months will be 3x after 2 months, 9x after 4 months, 27x after 6 months, 81x after 8 months, 243x after 10 months, and 726x after 12 months. Rounding again, 700*5000=3,500,000 after 1 year. 5000 to 4000000 in one year seems unlikely, but that seems to be the correct result for a basic compounding model using those starting values. Are you getting something similar? If it seems incorrect, then what financial assumption have I made that is incorrect?