Automated Mutual Fund Excel Dashboard
Краткое
Freelancer Client is hiring: Automated Mutual Fund Excel Dashboard.
Location: Remote
I keep a running list of every lumpsum, SIP and SWP I make, but right now all I have is a raw spreadsheet. I need a single Excel workbook that turns that manual entry into clear, fully-automated insights on my mutual-fund portfolio.
One Transactions sheet where I will continue to type or paste each deal (lumpsum, SIP, SWP, redemption, etc.).
A Holdings statement, organised the way mutual-fund investors actually think—fund-wise totals with units held, average cost, current NAV, current value, and unrealised gain/loss in both ₹ and %.
Dynamic reports that spin off automatically from the data:
Skills: Excel, Finance, Business Analysis, Financial Analysis, Excel VBA, Excel Macros, Data Visualization, Data Analysis
Budget: $5000–$10000 USD
Source: Freelancer Client via Remote / Online. Apply on the source website.
Оригинал
I keep a running list of every lumpsum, SIP and SWP I make, but right now all I have is a raw spreadsheet. I need a single Excel workbook that turns that manual entry into clear, fully-automated insights on my mutual-fund portfolio.
Here is what I have in mind:
• One Transactions sheet where I will continue to type or paste each deal (lumpsum, SIP, SWP, redemption, etc.).
• A Holdings statement, organised the way mutual-fund investors actually think—fund-wise totals with units held, average cost, current NAV, current value, and unrealised gain/loss in both ₹ and %.
• Dynamic reports that spin off automatically from the data:
– Detailed transaction register
– Valuation snapshot that recalculates the moment I update NAVs
– A concise summary page highlighting original investment, current value, absolute return, CAGR/XIRR and other key ratios.
If you can also leave hooks for future add-ons such as performance summaries, dividend tracking or capital-gains breakdowns, even better.
Deliverables
1. An unlocked Excel (.xlsx) file with all formulas, pivot tables/charts and VBA or Power Query (if used) clearly documented.
2. Short user guide explaining where I paste new transactions and how the calculations refresh.
3. Quick hand-off call or video walk-through after delivery.
Acceptance criteria
• Entering or editing a row on the Transactions sheet automatically updates the Holdings statement and all reports with no further input.
• CAGR/XIRR and valuation figures match sample numbers I will supply.
• Workbook performs smoothly on Microsoft 365 desktop (Windows).
If this sounds like your cup of tea, let’s get started—I’m ready to share my current file and sample data right away.
Локация & Details
Перейти к источнику →About this listing
This remote opportunity was imported from Freelancer and is shown here for discovery. To apply, follow the link to the original posting.