
In Progress
Posted
Paid on delivery
I need an Excel workbook that lets me compare contracted rent to current market rent for up to 12 separate leases and then values the difference over each lease’s remaining term. The sheet should be set up with nine clearly labelled columns: 1. Tenant Name 2. Suite Area (sq ft) 3. Actual Rent / sq ft 4. Market Rent / sq ft 5. Rental Disparity (3-4) 6. Months Remaining 7. Total Monthly Disparity (5 × 2) 8. Present Value Factor 9. Present Value of Disparity Key requirements • One yield rate – entered once at the top of the sheet – will drive every present-value calculation. Users will choose any figure they like (typical range 5-8 %), and the model must discount the monthly cashflow with that annual rate converted to a monthly factor. • The model must project each lease for its full remaining term even if it extends beyond five years; no hard limit at 60 months. • For clarity, show both positive and negative disparities because some leases sit above market while others fall below. • At the bottom, sum total square footage, undiscounted disparity, and the present-value disparity; display the final PV figure rounded to the nearest dollar. Usability touches – A clean input area (yellow cells or similar) so a non-technical user can paste tenant data quickly. – Automatic checks that warn if more than 12 rows are filled. – All formulas clearly visible (no hidden VBA needed). Deliverable An unlocked .xlsx file ready for immediate use, plus a brief note explaining how to change the global yield rate and add new leases later. I’ll consider the project complete when my sample data produces the correct monthly-discounted present values and totals.
Project ID: 40793933
131 proposals
Remote project
Active 6 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

A financial model that clearly compares contracted and market rent—and discounts every remaining monthly cash flow—matches the Excel and financial analysis systems I build. My recent work includes a VBA-driven investment forecasting model praised by the client as “masterfully executed,” along with bespoke Excel systems used in live business operations. I can create your unlocked workbook for up to 12 leases with a clearly marked input area, one global annual yield-rate cell, transparent monthly discounting formulas, unlimited remaining-term projections, visible positive and negative disparities, and summary totals for area, undiscounted disparity, and rounded present value. Excel’s formulas will remain visible with no hidden VBA dependency, and the workbook will include an automatic warning when entries exceed the 12-lease limit. My background Explore my impressive profile here: https://www.freelancer.pk/u/utrathore3 . Note: "Delivering success is our commitment. To achieve this, we carefully assess your project's scope, and then provide customized costs and timelines that meet your unique needs." Thanks and Best Regards, Usman Tariq Rathore Work-Nix Solutions
$30 USD in 1 day
8.2
8.2
131 freelancers are bidding on average $114 USD for this job

Hi there, I understand you need a 12-lease Excel model that compares contracted and market rent and values the gap over each lease’s remaining term. I am confident I can deliver a workbook whose present values reconcile exactly to your sample data, with every formula visible. My approach is to first build your nine columns on one sheet, with a single yield input at the top and yellow input cells for pasting tenant data. Next, I will convert the annual yield to a monthly rate and calculate each Present Value Factor with a closed-form annuity formula, so any remaining term works, including beyond 60 months, with a safeguard for a zero rate. I will then show positive and negative disparities with clear formatting, and add checks that warn if more than 12 rows are filled or inputs are missing. Finally, I will total square footage, undiscounted disparity and present value, round the final figure to the nearest dollar, and deliver an unlocked .xlsx with a short note on changing the yield and adding leases. Are your rents quoted per month or per year per sq ft, and should payments fall at month end or month start? I also have ideas for a small sensitivity table showing the present value at 5%, 6%, 7% and 8%, and input checks that flag missing or unusual rents before they reach the totals. Let’s start a chat to discuss requirements and next steps. Warm Regards, Aneesa.
$100 USD in 1 day
7.4
7.4

Hey! I have strong experience in Excel automation, financial modeling, and data analysis. I can build an unlocked, formula-driven lease valuation workbook that handles all 12 leases and calculates monthly discounted rental disparities using one global yield rate. Here’s how I can help: - Create all nine requested columns with clear input areas. - Apply one annual yield rate converted to a monthly discount rate. - Calculate full remaining lease terms without a 60-month limit. - Preserve positive and negative rental disparities. - Add automatic totals for area, undiscounted disparity, and present value. - Include a warning when more than 12 leases are entered. - Keep formulas visible, with no VBA or worksheet protection. I’ll also test the calculations using sample lease data and provide a brief guide explaining how to change the yield rate and enter new leases. Should the model assume constant monthly rent throughout each remaining lease term? Do you have sample figures to use for validating the final workbook?
$140 USD in 7 days
7.4
7.4

The usual trap here is the yield conversion: i/12 vs (1+i)^(1/12)-1 changes every PV figure, so I will match the convention your valuer uses. You get a draft loaded with your sample data within a day to check the PV column, then the final unlocked workbook plus the how-to note by day 3. Blank rows show empty, not zeros or errors, so the 12-row warning and totals stay clean. 1. Should the monthly factor be the annual yield divided by 12, or the true effective monthly rate? 2. Is rent treated as paid in advance (first month at t=0) or in arrears (t=1)? Happy to start right away if the sample data is ready to drop in.
$95 USD in 3 days
6.8
6.8

Excel and financial modeling are central to my work, making me well suited to build a reliable lease rental disparity workbook with clear, visible formulas. I can create the nine requested columns for up to 12 leases, showing both positive and negative disparities and calculating each lease’s full remaining term without imposing a 60-month limit. My expertise in Excel functions, formulas, formatting, data analysis, and financial analysis supports the required monthly discounting from one global annual yield rate. I will also make the workbook user-friendly with a clearly marked input area, automatic checks for entries beyond 12 leases, totals for square footage and undiscounted disparity, and a rounded final present-value figure. The deliverable will be an unlocked .xlsx file with a concise note explaining the yield-rate update and future lease additions. I am ready to create an accurate, practical model that your team can use immediately.
$200 USD in 1 day
6.6
6.6

Hello, I can create a professional, unlocked Excel workbook that compares contracted rent with market rent and calculates the present value of rental disparities across up to 12 leases. I’ll build the nine requested columns with clearly marked yellow input cells, visible formulas, and a single global annual yield-rate input that automatically converts to a monthly discount rate for each lease’s remaining term. The model will support both positive and negative rental disparities and calculate the full remaining lease period without a 60-month restriction. I’ll also include automatic totals for square footage, undiscounted monthly disparity, and present value of disparity, with the final PV rounded to the nearest dollar. An automatic warning will flag entries beyond the 12-lease capacity, and I’ll keep the workbook formula-driven without hidden VBA so it remains easy to understand and maintain. I’ll test the calculations using sample data, including leases extending beyond five years and both above-market and below-market rents, and provide a brief handover note explaining how to change the yield rate and enter new leases. Could you confirm whether you prefer clean sample data that you can overwrite or would like the workbook pre-populated with your actual lease figures?
$70 USD in 1 day
6.3
6.3

I'd build this as a transparent Excel model, with every formula visible and easy to audit. The workbook will handle up to 12 leases, use one editable yield rate, and calculate monthly-discounted present values across each lease's full remaining term—even beyond 60 months. I'll keep positive and negative rent gaps, add yellow input cells, clear totals, and a warning if the lease limit is exceeded. You'll receive an unlocked .xlsx and a short guide. I'll also test the formulas against your sample data. One question: are the rent-per-sq-ft figures annual? If so, the monthly disparity needs to be divided by 12. I can deliver within 2 days. Thanks!
$95 USD in 7 days
6.3
6.3

Hello, I went through your project description and understand you need an Excel-based lease valuation model that compares contracted rent with market rent and calculates the present value of each lease's remaining rental disparity. I will build an unlocked, formula-driven workbook with nine clearly labelled columns and a dedicated global yield-rate input at the top. I will use yellow input cells for tenant details, rent figures, suite areas, and remaining months, making data entry straightforward. I will calculate rental disparities with both positive and negative values preserved, derive total monthly disparities, and apply monthly discounting using the annual yield rate converted appropriately. The formulas will support the full remaining lease term without a 60-month restriction. I will also include automatic warnings for entries exceeding 12 leases, summary totals for square footage and undiscounted disparity, and a final present value rounded to the nearest dollar. I will test the calculations against your sample data and provide a brief usage guide. I will share a project blueprint within 24–48 hours of being awarded. To scope your project clearly, I would like to ask whether you will provide sample lease data and expected PV results for validation? Best Regards, Imran
$70 USD in 1 day
5.7
5.7

I’m ready to begin now and build the unlocked .xlsx lease disparity model for up to 12 leases. I’ll create the nine labelled columns, a single global yield-rate input, and visible formulas that discount each lease’s monthly disparity across its full remaining term, no mysterious 60-month cliff. I’ll also add clear input highlighting, positive and negative disparity handling, row-count warnings, and totals for area, undiscounted disparity, and rounded present value. I’ll test the calculations and include a brief usage note.
$30 USD in 1 day
5.3
5.3

I can create a clean, unlocked Excel workbook that accurately compares contracted and market rent across up to 12 leases and calculates the present value of each rental disparity over the complete remaining term. The workbook will include: - Clearly labelled columns for tenant, area, rents, disparity, months remaining, monthly disparity, PV factor, and PV disparity - A single global yield-rate input converted to a monthly discount factor - Support for lease terms beyond 60 months without artificial limits - Positive and negative disparities preserved correctly - Totals for square footage, undiscounted disparity, and present-value disparity, with the final PV rounded to the nearest dollar - Highlighted input cells for quick data entry - An automatic warning when more than 12 lease rows are populated - Visible formulas with no hidden VBA I’ll test the workbook against sample data to verify monthly discounting, full-term valuation, sign handling, and summary totals. I’ll also provide a concise usage note explaining how to update the yield rate and add leases later. I’m ready to build this as a practical, immediately usable .xlsx model with careful attention to calculation transparency and user experience.
$100 USD in 2 days
5.5
5.5

Hi. I'll create an Excel workbook that facilitates a comparison of contracted rent to current market rent across 12 leases, starting by setting up the nine specified columns and ensuring clarity within the structure. Next, I'll develop the formula to calculate the present value based on the yield rate inputted at the top of the sheet and incorporate checks to manage input limits and ensure usability for non-technical users. Each lease will be projected for its full remaining term, accommodating extensions beyond five years. Deadlines will be met, and I will ensure that communication remains clear throughout the project to address any specific requirements. Having constructed similar tools before, I'm confident the final deliverable will include a user-friendly .xlsx file along with instructions for managing the yield rate and adding leases. Are there particular range limits on the yield rate you prefer?
$140 USD in 7 days
5.3
5.3

Hi, each row's PV factor would be the monthly annuity factor over that lease's own months remaining, so a 140 month lease works the same way as a 24 month one Two quick questions, are your rents per sq ft quoted per year or per month, and for the monthly rate do you use yield/12 or the compounded (1+yield)^(1/12)-1, appraisers use both I work with Excel models a lot, the last one was a client's financial advice model that I wired into a desktop tool so it turns into a finished Word document If you send the sample data I'd check every row against it before you get the file
$60 USD in 1 day
4.8
4.8

Hi, I can build your Excel workbook with clear inputs, one global yield rate, and accurate monthly-discounted values covering each lease’s full remaining term. I’ll include totals, a 12 lease warning, visible formulas, and brief instructions, then check the calculations against your sample data before delivery.
$145 USD in 1 day
4.9
4.9

Hi, I can build the unlocked Excel model with your nine columns, a single yield input, visible formulas and clear input highlighting. The workbook will calculate each lease over its full remaining term, preserve positive and negative disparities, flag entries beyond 12 leases, and total area, undiscounted disparity and PV. Before implementing the formulas I would confirm two conventions: whether the quoted rents are monthly or annual per square foot, and whether the annual yield should convert to an effective monthly rate or a nominal rate divided by 12. I would also confirm the timing of the first cash flow. This prevents a clean-looking sheet from producing the wrong valuation. I will test sample leases, zero yield, zero remaining months and terms over 60 months, then include short usage notes. USD100 and three days covers the workbook and checks using your supplied assumptions; I am implementing the model rather than selecting a market rent or investment yield for you. — Nderim
$100 USD in 3 days
4.5
4.5

Hey, I'd put the yield in one yellow cell up top and turn it into a monthly rate right next to it, so every PV factor reads from that one place Column 8 would be a standard annuity factor on months remaining, so a 9 year lease is just n=108 in the same formula. Negatives would show in red, totals would sit at the bottom with the PV wrapped in ROUND, and a COUNTA check beside the input block would light up past row 12 Two quick ones for your sample - are the rents per sq ft annual or monthly, and do you convert the yield as r/12 or (1+r)^(1/12)-1? Either is a one cell change Send the sample over when you're ready and I'll check every row against it before the file comes back to you with the how-to note
$80 USD in 1 day
4.2
4.2

Hi, I can build a clean, unlocked Excel lease rental disparity model that compares contracted vs. market rent for up to 12 leases and calculates the monthly-discounted present value over each lease’s remaining term. I’ll set up: - Clear input fields for tenant data - A single global yield rate applied to all PV calculations - Formulas for monthly disparity, discounting, and totals - Support for positive and negative rent differences - Validation/warnings if more than 12 rows are used - A simple note explaining how to update the yield rate and add leases Everything will be formula-driven and easy for non-technical users to maintain. https://www.freelancer.com/u/GameOfWords If you’d like, I can also make the sheet visually polished and audit-friendly for quick review.
$30 USD in 7 days
3.8
3.8

Dear Client FinTax Global Solution is a team of CA, ACCA, CPA with 8 years of experience including Big 4 experience. We can coordinate with a qualified, experienced Excel financial modeling expert to assist with your lease rent disparity valuation model with present value calculation. We understand the requirement for 12 leases, 9-column structure, single global yield rate with monthly discounting, full remaining term projection beyond 5 years, and summed totals with clean yellow input area. A few questions before proceeding: 1. Should PV factor use end-of-month discounting? 2. Can you share sample lease data for validation? 3. What specific format is your lease data in? We look forward to assisting you. Best regards, FinTax Global Solution LLC
$140 USD in 7 days
3.9
3.9

Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, SYEDA NIMRA
$35 USD in 2 days
4.0
4.0

I can build a professional, fully formula-driven Excel lease valuation model that accurately calculates rental disparities and discounts monthly cash flows using one global yield rate. The workbook will be easy to use, transparent, and ready for immediate application without VBA or macros. I have gone through the requirements in detail. I will include: * All nine specified columns with clearly structured inputs and calculations. * A single adjustable annual yield rate converted into a monthly discount rate. * Accurate present-value calculations for each lease’s entire remaining term, without a 60-month restriction. * Positive and negative rental disparities. * Automatic totals for square footage, monthly disparity, undiscounted disparity, and rounded total PV. * Yellow input cells, formula protection-free design, and a warning when entries exceed 12 leases. * A brief user guide explaining yield-rate changes and adding leases. I have uploaded samples of similar Excel financial models and dashboards completed by me earlier in my profile. With 10+ years of experience as a Chartered Accountant (ICAI) and CPA, I bring strong financial modelling and Excel automation expertise. I will ensure the workbook is accurate, unlocked, well-formatted, and thoroughly tested against your sample data. I look forward to delivering a reliable model!
$70 USD in 1 day
4.1
4.1

Hello, I can build your Excel lease rental disparity and present-value model with transparent formulas, flexible assumptions, and support for up to 12 leases. I have strong experience in Excel financial modelling, property development models, cash-flow analysis, and present-value calculations. I will include: - A clearly identified input area for the global annual yield rate. - All nine requested columns with the exact headings and calculation logic. - Automatic conversion of the annual yield rate into a monthly discount rate. - Monthly annuity discount factors based on each lease's full remaining term, without a 60-month restriction. - Accurate positive and negative rental disparity calculations. - Automatic calculations of monthly disparity and present value for each lease. - Summary totals for square footage, undiscounted disparity, and total present value, rounded to the nearest dollar. - Validation checks and warnings if more than 12 lease entries are added. - Visible Excel formulas without VBA or hidden calculations. I will also test the workbook using sample lease data to verify the calculations, totals, and sensitivity to changes in the yield rate. I can start immediately and deliver an unlocked, user-friendly Excel workbook along with brief instructions for updating assumptions and adding leases. Best Regards, Sajjad
$50 USD in 1 day
4.0
4.0

Hi, I’ve read your requirements carefully and can build this as a clean, unlocked Excel model with no VBA. I’ll set up the 12-lease input area, one global yield rate, monthly discounted PV calculations, positive/negative rent disparities, automatic totals, and a warning if more than 12 leases are entered. My software engineering background helps me build and test formula-driven models carefully, including edge cases like leases beyond 60 months. For example, I can verify the workbook with sample leases manually to make sure the monthly discounting and final PV totals match exactly. I’ll also keep all input cells clearly highlighted and provide a short note showing how to change the yield rate or add more leases later. I can deliver a ready-to-use .xlsx file that is simple for any non-technical user to work with.
$100 USD in 4 days
3.6
3.6

Los Angeles, United States
Payment method verified
Member since Mar 9, 2026
$30-250 USD
$250-750 AUD
$25-50 USD / hour
£20-250 GBP
$15-25 USD / hour
$250-750 USD
₹12500-37500 INR
$20-30 NZD / hour
$250-750 USD
$5-10 USD / hour
$15-25 USD / hour
$15-25 USD / hour
$15-25 USD / hour
$20000-50000 USD
₹400-750 INR / hour
₹100-400 INR / hour
₹100-400 INR / hour
$250-750 USD
₹750-1250 INR / hour
$250-750 USD
$30-250 AUD