Lease and Loan Calculation

Excel lease and loan calculation for real estate and loan

Submit Excel Solution
Submit Solution [Guide]

Recently Added:
Business Intelligence Dashboards
Automation Add-ins
Financial Analysis Functions
Resource Demand and Planning
File Change Trigger
More Resources:
Excel Help Forum




Follow Business Spreadsheets On:
 
Find Excel Solutions:
Suggested text load results and icon loads solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity

Lease and Loan Calculation

Rate this solution:
(3/5 from 1 vote)
Buy Now
Lease and Loan Calculation screenshot
Pin It
 Lease and Loan Calculation for Excel is a time saving Excel add-in which organizes up to 100 lease or loan accounts into combined month end reports.

Lease and Loan Calculation for Excel calculates and combines current period payments of principal and interest, provides outstanding balances, months remaining, payments remaining and asset book values under straight line or declined balance depreciation schedules.

Starting input information includes the loan/lease principal, interest rate, repayment months, salvage percent and depreciation years.

The Lease and Loan Calculation for Excel program calculates the monthly repayment, and at each month end the periodic repayment of principal, interest charges, balance carried forward and book value carried forward.

The Excel add-in then consolidates all leases/loans into one overall month end summary report.

The Lease and Loan Calculation for Excel organizes multiple accounts using Excel tables that provide quick and easy look up and drill down to any lease/loan account and report of current balances. The program transforms all accounts into yearly principal and interest payments schedules based on daily interest to a maximum 20 year repayment period.

The Lease and Loan Calculation for Excel includes lease or loan repayment amortization schedules that accrues interest on the daily balance method for a maximum of up to 7,755 days - over 21 years, with daily accruals of interest based on 360 days, 365 days or 366 days.

Each account is created by entering the draw down date, repayment months, principal amount, annual interest rate, depreciation years and residual asset salvage value percent. The program creates the year by year repayment of principal and interest expense schedule for each account whether created in the past or anticipated in the future.

The Lease and Loan Calculation for Excel package also contains a demo tutorial.

Buy Now
Price: USD 99.95

Related Excel Solutions:Mortgage Calculation-Real Estate and Loan  Loan Analysis-Real Estate and Loan  Loan Calculator-Real Estate and Loan  Loan Amortization Templates-Real Estate and Loan  Depreciation Schedules-Financial Accounting

Share your thoughts with other users: Create your own review
 


Popular Searches




Add Economic Data to Excel Reports and Dashboards
See How Here

   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal | About Us