E-Commerce Store 3-Statement Financial Model

<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' stroke='%23337EA9' fill='none' stroke-linecap='round' stroke-linejoin='round'%3e%3cpath stroke='none' d='M0 0h24v24H0z' fill='none'/%3e%3ccircle cx='12' cy='11' r='3'/%3e%3cpath d='M17.657 16.657 13.414 20.9a2 2 0 0 1-2.827 0l-4.244-4.243a8 8 0 1 1 11.314 0z'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' stroke='%23337EA9' fill='none' stroke-linecap='round' stroke-linejoin='round'%3e%3cpath stroke='none' d='M0 0h24v24H0z' fill='none'/%3e%3ccircle cx='12' cy='11' r='3'/%3e%3cpath d='M17.657 16.657 13.414 20.9a2 2 0 0 1-2.827 0l-4.244-4.243a8 8 0 1 1 11.314 0z'/%3e%3c/svg%3e" width="40px" /> Navigation bar

</aside>

<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-yyzcwqmhxin1dqy27kk61c-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpath class='cls-yyzcwqmhxin1dqy27kk61c-1' d='M1.48 18.67h1.91l5 2.88a7.2 7.2 0 0 0 3.61.95'/%3e%3cpolyline class='cls-yyzcwqmhxin1dqy27kk61c-1' points='19.17 19.5 20.61 18.67 22.52 18.67'/%3e%3cpath class='cls-yyzcwqmhxin1dqy27kk61c-1' d='M12 22.5a7.26 7.26 0 0 0 3.58-.95l2-1.16-3.7-5.54-2.65.66a3.42 3.42 0 0 1-.79.09A3.23 3.23 0 0 1 9 15.26a1.5 1.5 0 0 1-.84-1.34 1.52 1.52 0 0 1 .91-1.38l5.08-2.17a3.79 3.79 0 0 1 3.57.33l1.93 1.3h2.87'/%3e%3cpath class='cls-yyzcwqmhxin1dqy27kk61c-1' d='M1.48 12h2.87l1.92-1.3a3.79 3.79 0 0 1 3.57-.33l2.16.93'/%3e%3cline class='cls-yyzcwqmhxin1dqy27kk61c-1' x1='22.52' y1='10.07' x2='22.52' y2='20.59'/%3e%3cline class='cls-yyzcwqmhxin1dqy27kk61c-1' x1='1.48' y1='10.07' x2='1.48' y2='20.59'/%3e%3cpath class='cls-yyzcwqmhxin1dqy27kk61c-1' d='M14.87 2.41h-3.71a1.07 1.07 0 0 0-1.07 1.08 1.07 1.07 0 0 0 .81 1l2.2.55a1.07 1.07 0 0 1 .81 1 1.08 1.08 0 0 1-1.07 1.16H9.13'/%3e%3cline class='cls-yyzcwqmhxin1dqy27kk61c-1' x1='12' y1='0.5' x2='12' y2='2.41'/%3e%3cline class='cls-yyzcwqmhxin1dqy27kk61c-1' x1='12' y1='7.2' x2='12' y2='9.11'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-yyzcwqmhxin1dqy27kk61c-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpath class='cls-yyzcwqmhxin1dqy27kk61c-1' d='M1.48 18.67h1.91l5 2.88a7.2 7.2 0 0 0 3.61.95'/%3e%3cpolyline class='cls-yyzcwqmhxin1dqy27kk61c-1' points='19.17 19.5 20.61 18.67 22.52 18.67'/%3e%3cpath class='cls-yyzcwqmhxin1dqy27kk61c-1' d='M12 22.5a7.26 7.26 0 0 0 3.58-.95l2-1.16-3.7-5.54-2.65.66a3.42 3.42 0 0 1-.79.09A3.23 3.23 0 0 1 9 15.26a1.5 1.5 0 0 1-.84-1.34 1.52 1.52 0 0 1 .91-1.38l5.08-2.17a3.79 3.79 0 0 1 3.57.33l1.93 1.3h2.87'/%3e%3cpath class='cls-yyzcwqmhxin1dqy27kk61c-1' d='M1.48 12h2.87l1.92-1.3a3.79 3.79 0 0 1 3.57-.33l2.16.93'/%3e%3cline class='cls-yyzcwqmhxin1dqy27kk61c-1' x1='22.52' y1='10.07' x2='22.52' y2='20.59'/%3e%3cline class='cls-yyzcwqmhxin1dqy27kk61c-1' x1='1.48' y1='10.07' x2='1.48' y2='20.59'/%3e%3cpath class='cls-yyzcwqmhxin1dqy27kk61c-1' d='M14.87 2.41h-3.71a1.07 1.07 0 0 0-1.07 1.08 1.07 1.07 0 0 0 .81 1l2.2.55a1.07 1.07 0 0 1 .81 1 1.08 1.08 0 0 1-1.07 1.16H9.13'/%3e%3cline class='cls-yyzcwqmhxin1dqy27kk61c-1' x1='12' y1='0.5' x2='12' y2='2.41'/%3e%3cline class='cls-yyzcwqmhxin1dqy27kk61c-1' x1='12' y1='7.2' x2='12' y2='9.11'/%3e%3c/svg%3e" width="40px" /> Description

Developed a dynamic 3-statement financial model for an e-commerce retail business, integrating revenue growth projections, debt financing (including a revolving credit mechanism), and cash flow forecasting. Designed the model to be scalable with built-in scenario analysis, allowing users to test multiple business cases. Implemented balance sheet integrity checks to ensure financial consistency and leveraged Excel automation to streamline forecasting assumptions.

File in Github link above.

</aside>

The model includes an Income Statement, Balance Sheet, and Cash Flow Statement, divided into “Actuals” and Projections based on historical trends and business assumptions**.**
All financial statements are interconnected, maintaining balance sheet accuracy and cash flow realism.
Integrated scenario testing to model financial outcomes under different revenue growth and cost structures.
Includes a revolver credit mechanism that dynamically adjusts borrowing based on cash flow needs.

income statement.png

balance sheet.png

</aside>