Financial Planning & Analysis

I created a detailed financial model for Novahan, a small financial institution in the Dominican Republic specializing in motorcycle loans. The model spans three years and is organized into different sheets. The Branches sheet likely contains branch-specific details. The Cash Flow sheet consolidates all financial data, showing income, expenses, and overall cash movement.

Old Sales track active loans, detailing outstanding balances and repayment schedules. Expenses break down operational and administrative costs. The Interest sheet displays payments to investors. Cost of the Motorcycle covers acquisition and maintenance expenses. Loans Income projects revenue from motorcycle loan sales.

The Sales Projection sheet forecasts future sales based on market trends. The Portfolio sheet combines old and projected sales, illustrating the portfolio's evolution. The Cash Flow Growth and EBITDA section demonstrates how the portfolio and profitability are expected to grow over time.

Additionally, there's likely a chart illustrating Inventory Movement to manage motorcycle stock effectively. Overall, the financial model provides a comprehensive view of Novahan's operations, financial performance, and growth projections. It's a crucial tool for understanding and managing the company's financial health.