1. Project Overview: Develop an Excel-based dashboard to manage and track financial data for six properties located abroad in Europe.
2. Objectives: • Consolidate mortgage details for each property, including remaining balance and monthly payments. • Track rental income from tenants for each property. • Calculate monthly profit for each property and overall profit. • Create a master summary sheet that aggregates data from all six properties. • Design individual tabs for each property that update the master summary in real-time.
3. Requirements: • Data Fields for Each Property: • Property Identifier (Name/Location) • Total Mortgage Amount • Remaining Mortgage Balance • Monthly Mortgage Payment • Monthly Rent Income • Monthly Profit (Rent Income minus Mortgage Payment) • Master Summary Sheet: • Aggregated data showing total mortgage balance, total monthly payments, total rent income, and total profit across all properties. • Individual Property Tabs: • Detailed breakdown of each property’s financials. • Real-time updates when new data is entered.
4. Deliverables: • A fully functional Excel workbook with one master summary sheet and six individual property tabs. • Clear instructions for data entry and updates.
Asisten Penjadwal Google Calendar Category: Admin Support, Data Entry, Event Planning, Excel, HTML, PHP, Project Management, Time Management Budget: $30 - $250 USD
24 Apr 2026 09:58 GMT
High-Res Logo Suite Creation Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Vector Design Budget: £20 - £250 GBP
24 Apr 2026 09:57 GMT
Web Code Validation Category: CSS, CSS3, Frontend Development, HTML, HTML5, JavaScript, PHP, Web Development Budget: £250 - £750 GBP
24 Apr 2026 09:57 GMT
N8N Order Quote Automation Category: API Integration, Docker, Excel, HTML, JavaScript, N8n, Vue.js, Web Development Budget: $250 - $750 USD
24 Apr 2026 09:54 GMT
AI Customer Support Chatbot Builder Category: AI Chatbot Development, AI Development, API Integration, HTML, Java, JavaScript, Natural Language Processing, PHP Budget: $250 - $750 USD
3D Promotional Motion Graphics Edit Category: 3D Animation, 3D Graphic Design, 3D Rendering, After Effects, Animation, Motion Graphics, Sound Design, Video Editing Budget: £18 - £36 GBP
UK Business Dispute Legal Assistance Needed Category: Contracts, Corporate Law, Employment Law, Legal, Legal Analysis, Legal Assistance, Legal Research, Litigation Budget: min £36 GBP
24 Apr 2026 09:43 GMT
Comprehensive Building Design Review Category: 3D Design, 3D Modelling, 3D Rendering, Architectural Engineering, AutoCAD, Building Architecture, Building Design, Home Design, Interior Design, Revit Budget: $250 - $750 USD