
Closed
Posted
I have a set of source documents that contain both narrative details and numeric figures, all of which must be transcribed into a Google Sheets workbook designed for ongoing financial tracking. Every row will hold mixed data—descriptive text in some columns, numbers in others—so accuracy on both fronts is critical. Beyond clean data entry, the sheet must automatically calculate key performance indicators using the built-in IRR and NPV functions. Once the records are in place I should be able to adjust any cash-flow figure and see the updated returns instantly, so please structure the worksheet with clear cash-in, cash-out and date columns linked to those formulas. Deliverables • Fully populated Google Sheets file with all source data entered exactly as provided • Correctly configured IRR() and NPV() formulas referencing dynamic cash-flow ranges • Quick note inside the sheet (or a short Loom clip, if you prefer) explaining where to add future transactions without breaking the calculations I’ll share the raw files and a field-by-field mapping right after kickoff. Let me know your estimated turnaround and any clarifying questions before you start typing.
Project ID: 40380319
11 proposals
Remote project
Active 30 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs