![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Dynamic Financial Model for Project Appraisal in Excel
- or -
Post a project like this£50(approx. $64)
- Posted:
- Proposals: 15
- Remote
- #4159076
- Expired
Designer and Developer|WordPress|Shopify|PSD|PHP HTML, JavaScript|WIX| PowerPoint/Keynote| Logo Designing
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX | 3D Architecture | Video Editing |Photoshop Expert
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Full Stack Web Development | SEO Writing | Graphic and Presentation Expert/C++ coding expert
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
UK-based Design Specialist | Skilled Multimedia Expert |Photo & Video Editor, Graphic designer, 2D Animator
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Graphic Designer|Video editing|2D/3D Logo I Animation | Content Writer | Web Content | Data Entry | Translator | Specialized in Power Point, Excel, Word, Translation
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Experienced Full Stack Web and App Developer |Android and IOS App Development| Project Management
![#3 in Social Media #3 in Social Media](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/f4ec0a78855bf9dcf78cb1126bf0bd50.png)
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Data entry, data mining, Microsoft excel,Microsoft Word, data scrapping, Power point etc
3811478315100510460466814635633061741070946190624789127320915235548997841091673410921588
![Babar A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/4bb17a285b3d03e94229aaedf5bc16fb_70x70.jpg)
![Armaghan A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/29108d4bf232f820a0e10142eb76097f_70x70.jpeg)
![Meesam A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/9e887c0753c3a68332fc182d98c9bc35_70x70.jpg)
![Fakhir K.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/dcb1064801766ed3572e1ac9644dd780_70x70.png)
![Riffat B.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/19e52118581bd8cd249c7dd31aa7a9d0_70x70.jpeg)
Description
Experience Level: Entry
I NEED EXCEL HELP URGENTLY. I HAVE ATTACHED A PDF OF THE EXAMPLE APPRAISAL AND WILL SUPPLY THE EXCEL SPREADSHEET ONCE I ACCEPT THE JOB. I NEED IT COMPLETED URGENTLY, IN THE NEXT 5 HOURS. PLEASE ONLY APPLY IF YOU CAN MEET THIS TIMELINE.
General Overview
Objective: Transform the static financial model into a dynamic one that updates in real-time as input values change. This involves replacing static values with formulas that automatically calculate revenues, costs, financing details, and profitability metrics.
Scope: The model includes several tables (Table 1 to Table 9) detailing project summary, financial appraisal, revenue calculations, cost breakdowns, financing structure, and sensitivity analyses.
Specific Instructions
Table 1: Project Summary
Action: No formulas required. This table provides a narrative overview of the project.
Table 2: Summary Financial Appraisal
Revenue Calculation:
Replace static sales revenue totals with formulas that multiply unit counts by their respective sizes and price per square foot.
Costs:
Site Purchase Costs: Sum purchase price, stamp duty, and other purchase costs.
Build Costs: Sum preliminary costs, main build costs, and contingencies.
Other Costs: Include formulas to calculate fees, marketing, and statutory costs as percentages of build costs or GDV.
Financing:
Finance Costs: Calculate interest on loans based on principal amounts and rates.
Profitability Metrics:
Net Profit: GDV minus total costs (including finance costs).
ROI, RoE, and other returns: Use Excel functions to calculate these based on net profit and investment amounts.
Tables 3 to 6: Detailed Breakdowns
Action: Implement formulas to calculate detailed revenue and cost components, such as per-unit sales revenue, construction cost per square foot, and professional fees as percentages of total costs.
Table 7: Finance Structure
Senior Debt and Mezzanine Financing:
Calculate total facilities, interest, and fees as specified percentages of project costs or GDV.
Developer's Equity:
Detail equity contributions and expected returns using formulas based on project profit and equity investment.
Table 8: Sensitivity Analysis
GDV and Build Cost Variations:
Use formulas to show how changes in GDV and build costs impact return on cost and profit. Adjust GDV and build costs by specified percentages and recalculate key financial metrics.
Table 9: Advanced Financial Analysis
Detailed Financial Projections:
Implement complex formulas for cash flow projections, detailed cost analysis, and financing repayment schedules.
Additional Instructions
Cell Referencing: Ensure all formulas correctly reference input cells, dynamically pulling values from relevant parts of the spreadsheet.
Cross-Table Dependencies: Identify and link inputs across tables where changes in one affect calculations in another (e.g., changes in build costs impacting total costs and financing needs).
Validation and Testing: After implementing formulas, validate the model by testing with various input scenarios to ensure accuracy and responsiveness.
Documentation: Provide clear documentation within the spreadsheet (using comments or a separate instruction sheet) detailing the logic behind key formulas and any assumptions made.
General Overview
Objective: Transform the static financial model into a dynamic one that updates in real-time as input values change. This involves replacing static values with formulas that automatically calculate revenues, costs, financing details, and profitability metrics.
Scope: The model includes several tables (Table 1 to Table 9) detailing project summary, financial appraisal, revenue calculations, cost breakdowns, financing structure, and sensitivity analyses.
Specific Instructions
Table 1: Project Summary
Action: No formulas required. This table provides a narrative overview of the project.
Table 2: Summary Financial Appraisal
Revenue Calculation:
Replace static sales revenue totals with formulas that multiply unit counts by their respective sizes and price per square foot.
Costs:
Site Purchase Costs: Sum purchase price, stamp duty, and other purchase costs.
Build Costs: Sum preliminary costs, main build costs, and contingencies.
Other Costs: Include formulas to calculate fees, marketing, and statutory costs as percentages of build costs or GDV.
Financing:
Finance Costs: Calculate interest on loans based on principal amounts and rates.
Profitability Metrics:
Net Profit: GDV minus total costs (including finance costs).
ROI, RoE, and other returns: Use Excel functions to calculate these based on net profit and investment amounts.
Tables 3 to 6: Detailed Breakdowns
Action: Implement formulas to calculate detailed revenue and cost components, such as per-unit sales revenue, construction cost per square foot, and professional fees as percentages of total costs.
Table 7: Finance Structure
Senior Debt and Mezzanine Financing:
Calculate total facilities, interest, and fees as specified percentages of project costs or GDV.
Developer's Equity:
Detail equity contributions and expected returns using formulas based on project profit and equity investment.
Table 8: Sensitivity Analysis
GDV and Build Cost Variations:
Use formulas to show how changes in GDV and build costs impact return on cost and profit. Adjust GDV and build costs by specified percentages and recalculate key financial metrics.
Table 9: Advanced Financial Analysis
Detailed Financial Projections:
Implement complex formulas for cash flow projections, detailed cost analysis, and financing repayment schedules.
Additional Instructions
Cell Referencing: Ensure all formulas correctly reference input cells, dynamically pulling values from relevant parts of the spreadsheet.
Cross-Table Dependencies: Identify and link inputs across tables where changes in one affect calculations in another (e.g., changes in build costs impacting total costs and financing needs).
Validation and Testing: After implementing formulas, validate the model by testing with various input scenarios to ensure accuracy and responsiveness.
Documentation: Provide clear documentation within the spreadsheet (using comments or a separate instruction sheet) detailing the logic behind key formulas and any assumptions made.
![MD87 ..](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/1760f76b94c01c21fc945ac2bc879607_150x150.jpg)
MD87 ..
100% (35)Projects Completed
31
Freelancers worked with
28
Projects awarded
31%
Last project
10 Feb 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies