JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
Yearly General Financial Records
Yearly General Financial Records
Simple Liquid Audit Trail Report
More
Share
Explore
2023- 2024 (prior to accounting)
2024 prior to accounting
Sum of Net Income for 2024 thus far:
98,511
Table 4
Table 4
Date
Gross Income
Expenses
Net Income
Notes
Date
Gross Income
Expenses
Net Income
Notes
1
1/7/2024
2
1/14/2024
3
1/21/2024
2,600
4
1/28/2024
5
2/4/2024
5,800
6
2/11/2024
2,350
7
2/18/2024
2,770
8
2/25/2024
9
3/3/2024
18,710
10
3/10/2024
4,441
11
3/17/2024
4,900
12
3/24/2024
6,970
13
3/31/2024
3,790
14
4/7/2024
10,120
15
4/14/2024
2,790
16
4/21/2024
6,900
17
4/28/2024
1,870
18
5/5/2024
3,700
19
5/12/2024
6,900
20
5/19/2024
2,600
21
5/26/2024
11,300
There are no rows in this table
98,511
Sum
2024 Average Income Growth Rate is 8.51%
2024 Average Income Growth Rate is 8.51%
1
2024 Chart Entries
2024 Chart Entries
1
2024 weekly Rate of Change
2024 weekly Rate of Change
Formula
Average Growth Rate=(∏_i
^n
=1(1+r_i)
^
1/n−1
Where:
ri
is the rate of change for each period (in decimal form).
n
is the number of periods (21 weeks).
Step-by-Step Process:
Convert Weekly Percentage Changes to Decimal Form
:
Convert each weekly percentage change to a decimal by dividing by 100 (e.g., 19.811321% becomes 0.19811321).
Add 1 to Each Decimal Change
:
This step accounts for the growth factor. For example, if a week's rate of change is 0.19811321, it becomes 1.19811321.
Compute the Product of All Growth Factors
:
Multiply all the growth factors together to get a single product value.
Take the nnnth Root of This Product
:
Since there are 21 weeks, take the 21st root of the product from the previous step.
Subtract 1 from the Result
:
This gives the average growth rate in decimal form.
Convert Back to a Percentage
:
Multiply the result by 100 to get the average growth rate as a percentage.
Example Calculation:
Assuming we have the weekly rate of changes in percentage for 21 weeks (excluding NaNs):
Convert Weekly Percentage Changes to Decimal Form
:
Example: 19.811321% becomes 0.19811321
Add 1 to Each Decimal Change
:
Example: 0.19811321 becomes 1.19811321
Compute the Product of All Growth Factors
:
Example: 1.19811321×1×0.73464567×0.5187567×2.68595041×0.99230769×0.64341085×4.14168675×0.14952292×3.65758755×0.77659574×0.89041096×0.89892308×1.54150265×…1.19811321 \times 1 \times 0.73464567 \times 0.5187567 \times 2.68595041 \times 0.99230769 \times 0.64341085 \times 4.14168675 \times 0.14952292 \times 3.65758755 \times 0.77659574 \times 0.89041096 \times 0.89892308 \times 1.54150265 \times \ldots1.19811321×1×0.73464567×0.5187567×2.68595041×0.99230769×0.64341085×4.14168675×0.14952292×3.65758755×0.77659574×0.89041096×0.89892308×1.54150265×… (continues for all 21 weeks)
Take the 21st Root of This Product
:
(product of growth factors)121\left( \text{product of growth factors} \right)^{\frac{1}{21}}(product of growth factors)211
Subtract 1 from the Result
:
(product of growth factors)121−1\left( \text{product of growth factors} \right)^{\frac{1}{21}} - 1(product of growth factors)211−1
Convert Back to a Percentage
:
((product of growth factors)121−1)×100\left( \left( \text{product of growth factors} \right)^{\frac{1}{21}} - 1 \right) \times 100((product of growth factors)211−1)×100
Using the given data, the average growth rate over the 21 weeks is calculated to be approximately 8.51%.
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.