rentals calculations

  1. D

    Billing Calculation Formula

    I am needing help with creating a formula that calculates the total cost of the equipment rental for the estimated says on rent. It is based off a 28 day billing cycle. i.e. i have the equipment from 8/1/2021 - 8/30/2021, then the company would bill be a monthly rate plus two daily rates. The...
  2. K

    Calculate Total Owed with Multiple Non-consistent Payments

    I don't believe that this particular question has been asked so if it has I apologize in advance. I am provided with a pdf of a transaction log from my client/landlord for each tenant that they are requesting Eviction proceedings for. It looks like this: Now I have to convert this to an...
  3. H

    RE: Office Tenant - Rental Status Sheet

    RE: Office Tenant - Rental Status Sheet Hi I am looking to create a worksheet which works out how much rent is still outstanding for a particular client in an office building. The worksheet should act as a statement of account / rent ledger showing the client the dates they were invoiced,the...
  4. T

    Staggered rent calculation.

    Hi, Some friends of mine and I are staying in a villa for a set total cost £3780. But 7 people will stay for the full 3 weeks, 1 person will stay for 2 weeks, and 2 people will stay for 1.5 weeks. How do I calculate how much each person has to pay?
  5. XL Pro

    Help with formula to calculate rentals.

    I have a worksheet that reports the total number of days a piece of equipment has been on a site for a month. The breakdown works like this: 4 rental days = 1 week 12 rental days = 1 month So, if a piece of equipment is rented for 6 days, we want to calculate it as 1 week (5 days) and 1 day...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top