Apple Numbers Expert Needed: Financial Model Review / DO NOT APPLY UNLESS YOU WORK IN APPLE NUMBERS
Budget: $750 – $1,500 USD
We are seeking an experienced financial analyst to rebuild and enhance an existing financial model for a hospitality development project. The current model is in Apple Numbers, and we require it to be recreated and improved in Microsoft Excel.
Scope of Work:
1. Model Recreation:
• Rebuild the existing financial model from Apple Numbers into Microsoft Excel.
• Ensure all existing functionalities and calculations are accurately transferred.
2. Model Enhancement:
• Update the model including the following sheets:
• IRR Summaries
• Key Assumptions
• Financial Summary
• Memberships
• Hotel Operations
• Food & Beverage (F&B)
• Spa
• Other Income Streams
• F&B Assumptions
• Payroll
• Sources and Uses of Funds
3. Assumptions Dashboard:
• Create a centralized “Assumptions” sheet to serve as the main dashboard.
• Link all key variables and inputs throughout the model to this dashboard.
• Enable easy adjustment of figures, with changes automatically flowing through the entire model.
4. Formulas and Linking:
• Ensure all formulas are correctly implemented and cells are properly linked.
• Maintain consistency and accuracy across all sheets.
• Use best practices for financial modeling, including clear labeling and organized formatting.
5. Functionality and Usability:
• Optimize the model for ease of use and clarity.
• Include data validation where appropriate to prevent input errors.
• Provide the ability to perform sensitivity analysis and scenario planning.
6. Deliverables:
• A fully functional Excel-based financial model with the enhancements outlined above.
Scope of Work:
1. Model Recreation:
• Rebuild the existing financial model from Apple Numbers into Microsoft Excel.
• Ensure all existing functionalities and calculations are accurately transferred.
2. Model Enhancement:
• Update the model including the following sheets:
• IRR Summaries
• Key Assumptions
• Financial Summary
• Memberships
• Hotel Operations
• Food & Beverage (F&B)
• Spa
• Other Income Streams
• F&B Assumptions
• Payroll
• Sources and Uses of Funds
3. Assumptions Dashboard:
• Create a centralized “Assumptions” sheet to serve as the main dashboard.
• Link all key variables and inputs throughout the model to this dashboard.
• Enable easy adjustment of figures, with changes automatically flowing through the entire model.
4. Formulas and Linking:
• Ensure all formulas are correctly implemented and cells are properly linked.
• Maintain consistency and accuracy across all sheets.
• Use best practices for financial modeling, including clear labeling and organized formatting.
5. Functionality and Usability:
• Optimize the model for ease of use and clarity.
• Include data validation where appropriate to prevent input errors.
• Provide the ability to perform sensitivity analysis and scenario planning.
6. Deliverables:
• A fully functional Excel-based financial model with the enhancements outlined above.