$737 is the "regular" payment amount for a 30-year loan. To explain this method, I have taken the following dataset. To amortize ROU asset, you need to allocate the cost of the asset over the lease term. Click Save. + After PwC, she joined a consulting firm and assisted companies in navigating complex technical accounting matters and streamlined their monthly close processes. Direct costs of $25,000 at initial recognition: This will increase the ROU asset to 141,357.12 ($116,357.12 + $25,000) and the straight line lease payments to 396.17 ($25,000 + 120,000)/366. The lease liability is defined as the present value of your future lease payments. You may use the mathematical formula to calculate the monthly lease payments. Branch Motors' interest rate for determining payments was 8%. If you're unaware of the new lease accounting standard, ASC 842, here's a quicksummary. The last two arguments are optional, the residual value defaults to zero; payable in advance (for one) or at the end (for zero) is also optional. However, if the commencement date falls at or near the end of the economic life of the underlying asset, this criterion shall not be used for purposes of classifying the lease. Select the lease liability amount and apply the applicable discount rate, this rate has been divided by 12 to be consistent with the NPV formula as the payments are monthly. Show payment schedule. Lauren Covell is a Certified Public Accountant who currently lives in St. Louis, Missouri. Click OK to have Excel run the goal seek analysis. By comparing these amounts, you can determine which is the better value for you. 45% of $20,000 = $9,000. When the lease ends, the . A modification of the lease agreement occurs on 2020-10-16 for fixed payments to increase to $12,000 starting on 2020-11-1, An updated discount rate of 6% in CELL D5. Just enter the appropriate cash flows such as the lease, payments, and residual, and then type "U" for Unknown for the Nominal Annual Rate. The lease calculator shows you the monthly lease payments and the total interest amount in seconds. The lease liability has been paid. Keep it simple. Values: $10,000 at the start of each month, On 2020-10-16, the fixed payment amount increased to $12,000 on 2020-11-1, The appropriate discount rate at modification is 6.00%. It's essentially like accounting for all your leases as if they were capital leases under ASC 840. ASC 842 requires lessees to bring all leases on the balance sheet. Thanks for reaching out! Lease schedules are often prepared at the inception of a lease, as they are utilized as a guide for projected payments over the course of a lease. Periodic lease payment amount that the lessee pays to the lessor. When you enter "0" for both "Periodic Payment" and "Final/Balloon Payment," you are setting up the calculator to calculate a level payment for the entire term of the loan. It is most commonly associated with car leasing. But that's just the tip of the iceberg when it comes to leasing accounting. Thanks for the question. If the file type is not already set to "Excel Workbook (*.xlsx)," select that option from the drop-down menu (below the file name) now. You can see in the formula that the discount rate is divided by 12, given the monthly payments. This is the amount the lessor (finance company) pays for the asset today, at the start of the lease term. Should you lease or buy? window.__mirage2 = {petok:"HluSubMNpm6Zmc2EhDAdIivJm3mp56QDEJ2pWGeBLjs-1800-0"}; In reference to Example 1, the discount rate is 7%. This loan amortization calculator Excel template can be used for a home mortgage loanone of the most common types of amortizing loans. Then in step 7, expense is negative and appears to be increasing incrementally by 6%. b. Using Excel, calculate using the NPV formula. Apply the closing balance of the previous month, as that is opening balance for the next month. 444 Alaska Avenue formId: "7b841091-0b3b-4af0-888a-731226443850" For Interest Rate, assuming you have good credit, use the current new-car 36-month loan rate. Well break down the calculation in reference to the above picture column by column. On the Amortization Schedule ribbon, choose Fiscal Year from the Settings menu button or from the Settings group to display the Fiscal Year setting. Determine the term of the lease. 140 Yonge St. Do you still have questions? 140 Yonge St. Read about ASC 842 & other lease accounting topics, By LeaseCrunch on May 9, 2022 at 2:12 PM. If your books follow FASB ASC 842, lease amortization is calculated differently depending on whether you have a finance vs. operating lease. Please kindly reply me the correct recording. The Excel formula used to calculate the monthly . Check it out! Instructions for using the calculator are as follows. QuickBooks Online, on the other hand, does not have this feature natively, but you can use a third-party app or a loan amortization calculator to create an amortization schedule and then import the data into QuickBooks Online. The rate applied has the biggest impact on present valuemuch bigger than exactly when a payment is made within the period. It's important to note that there are certain exceptions and exemptions to the capitalization requirements under IFRS 16 and GAAP, such as short-term leases and leases of low-value assets. So: $5,000 + $14,161.64 + $14,000 - $30,000 = $3161.74. Create input fields at the top of your spreadsheet to record the following key data that drive your amortization schedule results, 2. This gives us a lease liability of $452,048.88 and ROU Asset of $459,548.88. If youve forgotten to make the correct updates to the calculation the lease liability will not unwind to zero by 2020-12-1. Periodic lease payment amount that the lessee pays to the lessor. Subtract the $448.12 from the daily interest amount to get the ROU amortization amount. An amortization schedule, sometimes called an amortization table, displays the amounts of principal and interest paid for each of your loan payments. 4. Keep it simple and consistent when creating a compliant schedule. A lessee must recognize a right-of-use (ROU) asset and lease liability. This article is demonstrating how to build an amortization table using the effective interest method in Excel. About Us For this example, the lease is for office space within an office building. Case Studies. Incentive payments payable at lease commencement reduce the lease payment(s) in the month they are due. The lease has been categorized as an operating lease, and the entity has determined that its total fixed rent to be $475,000 ($500,000-35,000+10,000) Therefore, on an annual basis, it will recognize $95,000 of fixed rent expense. So youve read the guidance, and now youre good to go. Are spreadsheets really the right call for ASC 842. For a finance lease, which means the characteristics of the lease make it similar to purchasing the underlying asset, an interest expense must be considered for the remaining lease liability. display: none !important; Step 2 Enter the residual value (R). }, PricingASC 842 SoftwareIFRS 16 SoftwareGASB 87 SoftwareGASB 96 Software, Why LeaseQuery Free rent, or rent abatement, is not included in the initial lease liability or ROU asset calculation. This opens the Financial Function drop-down list. So its time to put theory into practice and calculate the lease liability. Residual value: 45%. A lessees obligation to make the lease payments arising from a lease, measured on a discounted basis. Lease Liability Calculation and Amortization Schedule PV(rate, nper, pmt, [fv], [type] Calculates present value Interest rate revelant for each period (APR/m) rate nper pmt Residual payment of lease [fv] Type (payment due at beginning or end of period) [type] Present value of lease payments PV Adjustments to Lease Liability Balance If you would like a copy of the lease calculation in excel, please reach out to [emailprotected]. For further information on how to determine the appropriate discount rate refer to this material. It's now operating leases and finance leases. [CDATA[ Then select Books > Asset depreciation schedule to open the Asset depreciation schedule page. This gives us a lease liability of $452,048.88 and ROU Asset of $459,548.88. Careers, Security | Accessibility | Terms & Conditions | Privacy Statement. Enter the car's MSRP, final negotiated price, down payment, sales tax, length of the lease, new car lending rate. Advantages This data will be taken directly from the lease agreement. These entries can be created for each lease, or they can be created for multiple leases by using the batch journal functionality. Residual value $12,500.00. Using Example 1 the total number of days in the lease is 366 days (2020 is a leap year). Enter lease payment information in the lease payment column. Its not as accurate compared the daily schedule due to: Create five columns within the Excel worksheet. Otherwise, it is a short term/low value lease that should be expensed. Payments that are related to other components like services are not classified as lease payments. In Step 7 we populated the liability balance column with the formula of the prior period end liability balance less the calculated liability reduction. How to create the lease amortization schedule and calculate your lease liability, Enter the number of periods and cash payments, Perform What-If Analysis on liability balance, Set liability balance value to 0 with goal seek, how to calculate the present value of lease payments using Excel spreadsheets, Discount Rate Implicit in the Lease under ASC 842, Interest Rate Implicit in the Lease under IFRS 16, ASC 842 Lease Accounting: Summary, Examples, Effective Dates, and More, Incremental Borrowing Rate for IFRS 16, ASC 842, and GASB 87: Discount Rates, IFRS 16 Summary and Two Full Lease Accounting Examples for Lessees, Rent Expense: Straight-Line Rent Calculation for Leases under US GAAP Explained, https://leasequery.com/blog/prepaid-rent-other-rent-accounting-under-asc-842-explained/, https://leasequery.com/blog/capital-lease-accounting-finance-lease-accounting-example/, Operating Lease Accounting under the New Standard, ASC 842: Full Example and Explanation. seven Please check back soon, as we have an article on incentives that will be published in a couple of weeks. 14 Youll know that you have an operating lease if the estimated economic life of the asset is less than 75% and the net present value (NPV) is at least 90% of the leases total value. Cradle Inc. Step 3) Enter "0" for expense in period 0 and period 1 (because payments are made in advance). In the above example, its straightforward, the right of use-value equals the lease liability value of $116,357.12. The fair market value lease, an operating lease also known as a 'true' lease, provides the lessee with a great deal of flexibility at the conclusion of the lease period. In this case, the intangible asset is the lease itself, not the underlying asset that is being leased. b) Calculate the number of days in the agreement: A quick way to do this in Excel is to use the COUNT function and count the number of rows used (it can be any column). Once you have determined the discount rate, you have all the inputs to complete the updated lease liability's present value calculation based on the modified terms. Podcast Learn about the minimum lease payments, future lease payments, and how up calculate to present value of get lease how inside Excel for accounting. For example, an accountant will often use a lease amortization schedule as a reference to ensure that payments, interest, and amortization are properly recorded on financial statements throughout the term of the lease. Drag this formula down to populate cells B10 through B14. 5. Once those steps are complete you have finished the calculations necessary for a modification of an increase in fixed payments for an operating lease under ASC 842. So the lease payment for year two will be $102,000. Identifier of the accounting ledger. ; Residual Value how much this vehicle will be worth at the end of your lease term. The closing balance of the lease liability should unwind to zero. After the first year, the CPI has increased by 2 percent. (Round answers to 2 decimal places, e.g. - with the push of a button from LeaseCrunch. Columns. Lease Abstraction With NetLease Complete: How NetLease Completes Lease Abstraction Helps, Free Lease Accounting Software that Actually, ASC 842 Guide to Operating Lease Journal Entries. In exchange for that, the lessor receives periodical payments at pre-determined dates. In this method, I will explain how to calculate a lease payment in Excel by employing the PMT function. The key differences compared to Example 1 are: If you would like the excel calculation for Example 2, please reach out to[emailprotected]. Lease price $24,000.00. Last Updated on February 9, 2023 by Morgan Beard. I recommend the daily schedule as its not that much more of a time investment than the monthly NPV lease liability calculation we're about to go through. Monthly Amortization Entry: debit Lease Expense, debit Allocated to Principal, credit Payment and credit ROU Asset Adjustment (plug). Under an operating lease, the lessee (the person or company using the asset) does not take ownership of the asset at the end of the lease term. See below. c) Divide total expense by number of days to get the straight-line lease expense, Using Example 1 the straight-line lease expense is $327.87 (120,000 / 366), d) Subtract the daily straight-line lease expense by the daily interest expense which gives you the amortization expense, Using Example 1 on 2020-1-1 the ROU amortization expense is $308.15 ($327.87 - 19.72), e) Ensure the ROU asset is amortized to $0. The early majority amount is of interest while later the amount of principal loan is in the schedule. . Dont forget, were making assumptions in our application of 842. Your ending balance equals the prior period ending balance, payments received, plus liability accretion (interest accrued during the period), Prior Period Balance less Asset Adjustment, This is the least intuitive field to include, but its the amount to apply against the ROU asset that balances your journal entry. In expense for period 2, enter the cell for the period 1 liability balance and multiply by 6%. n. number of payments over the loan's lifetime Multiply the number of years in your loan term by 12 . Here are the following steps to take when calculating the ROU asset amortization schedule: a) Calculate the straight-line lease payment: Add up the total lease expense that is known at the outset of the commencement of the lease. Use this lease term to determine the amortization period, or the period of time it will take a company to pay off a lease. It is the product value plus total interest. In simple words, residual value subtracted from the original price gives you the amount you pay to the lessor. The Nominal Annual Rate is the implicit rate or . This means that the total rent expense is spread evenly over each period of the lease, rather than being front-loaded or back-loaded. In QuickBooks, the availability of an amortization schedule depends on the version of the software being used. To calculate an auto lease, you need to think about several factors: Price of the Car - the total amount the dealership is charging for this vehicle. Enter 0 for the Liability Balance in the line above period 0. Contact +1 (888) 738-8030 [emailprotected], Head Office If youre using a lease accounting software, the information above will help you cross-check the calculations performed by your provider so you can ensure accuracy. Your cost would jump from $8,000 spread out over your lease to $11,000. Or are you interested in scheduling a demo to see how our software can build your business amortization schedules with a push of a button? Residual value ("residuals"), in car leasing, refers to the estimated repeat, estimated wholesale value of a leased vehicle at the end of the scheduled lease term. Below you can find the results of all five functions. So the first input of the calculation to figure out iswhat are future known lease payments at commencement. This is calculated as the initial step in accounting for a lease under ASC 842, and this amount is then used to calculate the ROU (right-of-use) asset, that is recorded in addition to the liability for operating leases and capital leases. The ROU asset is then reduced - or amortized - monthly until the last payment. Leasing is a widely used alternative form of financing for companies. Microsoft offers a variety of lease templates through its Microsoft office software suite. To get the total number of payment periods, we multiply it by 12. Moving on to the Lease Amortization Schedule itself. In this how-to guide, well cover how to calculate a monthly lease liability amortization schedule. When transitioning to the new lease accounting standard, the standard allows you to grandfather previous lease classification under ASC 840. Under ASC 840-20-25-1, it prescribed the following treatment: Rent shall be charged to expense by the lessee over the lease term as it becomes payable. The APR for this lease is 6%. Hello, I am trying to replicate the schedule using your instructions and not having success. The lease term is for the major part of the remaining economic life of the underlying asset. The monthly expense may be different from the monthly lease payment as we are now including interest as part of the operating lease expense, different from how operating leases were handled under ASC 840. QuickBooks Desktop has a built-in loan amortization feature that allows you to create and track an amortization schedule. I'd recommend the following articles which can add to your knowledge of lease accounting and save yourself a lot of time in the future: Here at Cradle, our mission is simple; it's at the foundation of everything that we do. Transitioning to ASC 842, IFRS 16, and GASB 87 can be difficult, but there are resources that can help you gain an understanding of the methods laid out below for our calculations. The Total Remaining Lease Costs equals Total Lease Payments + Unamortized Initial Direct Costs Lease Incentives Prior Period Lease Costs. Loan amortization schedule excel format Lease a car for one year uk Mortgage loan interest rates in union bank of india Payment calculator for auto loan with down payment calculator Auto interest rate comparison . The formula for French straight - line depreciation is created in cell C9. Hi, Suite #73591 Date of the periodic lease payment invoice. This schedule will provide you with the calculations for your journal entries for the entire life of the lease, if youre using Excel. Whether financing or operating, you can easily make an operating lease schedule that meets the requirements under ASC 842. You should be able to find answers in our article that covers prepaid rent: https://leasequery.com/blog/prepaid-rent-other-rent-accounting-under-asc-842-explained/, Please I need clarity on Capital lease in the book of the lessee. For a direct financing lease, amortization of the initial direct costs should be recorded as a reduction of interest income, rather than as an expense, in accordance with ASC 835-30-45-3 . You have a basic understanding that the lease liability is the present value of the future lease payments at commencement. She started her career in the PwC audit practice. The free version is fully functional calculator with only one restriction - you can't change the interest rate. End of Period Payments: =npv(rate/12,period1pmt:finalperiodpmt), Beginning of Period Payments: =npv(rate/12,period2pmt:finalperiodpmt)+period1pmt. As an example, a car worth $30,000 that is leased for 3 years can have a residual value of $16,000 when the lease ends. The term of the non-cancelable lease is 3 years with no renewal option. Input key data at the top of your spreadsheet to drive your amortization schedule results. A finance lease is defined as an agreement in which ownership is transferred to the lessee, who is now responsible for the maintenance of the leased asset, including insurance and taxes, at the end of the lease term. Once you have determined the discount rate, you have all the inputs to complete the XNPV formula in Microsoft Excel. : Input the monthly payments for each period of the lease term. The lease liability is defined as the present value of your future lease payments. Selling price: $20,000. Lease liability should run down to 0 at the end of the lease. The only exception is if at lease commencement, the lease term of 12 months or less. Lease commissions refer to the fees paid to a broker or other agent for arranging a lease agreement between the landlord and tenant. Building an amortization schedule, when not built by lease accounting software, most frequently begins in Excel. To calculate the present value of the modified future lease payments, an additional column has been added. Get the latest and most important lease accounting information right to your inbox. The amortization of ROU asset is the process of systematically reducing the value of the asset over time to reflect its decreasing value as the lease term progresses. In the top bar in Excel, go to the Data tab, then the What-if Analysis Tab, then select Goal Seek.. For most assets, the longer the lease period, the lower the residual value. Here are a few principles to consider before getting started: 1. We've gone through one way to calculate a lease amortization schedule. Under ASC 842, regardless of the lease classification, the lease is coming on the balance sheet. The devil is in the detail when calculating modifications. The calcuation for the incremental borrowing rate is quite complex and we suggest seeking assistance from your finance and/or treasury department(s) to determine the correct rate for your organization. Right of use asset: the lessee's right to use the leased asset. Calculating a Lease Amortization Schedule, View Side-by-Side Financial Statement Examples, A Comprehensive Guide to the New Lease Standard. In navigating complex technical accounting matters and streamlined their monthly close processes are... Payment and credit ROU asset of $ 116,357.12 lease payments above Example, its straightforward, the call. A leap year ) to put theory into practice and calculate the.! Adjustment ( plug ) is then reduced - or amortized - monthly the. How much this vehicle will be worth at the top of your payments. The amounts of principal and interest paid for each lease, if youre using Excel on whether you have finance... How-To guide, well cover how to calculate a lease liability of 459,548.88. Amortization schedule Louis, Missouri 's essentially like accounting for all your leases as if they were capital leases ASC... Will explain how to determine the appropriate discount rate, you can find the results all! So its time to put theory into practice and calculate the lease is for office space within office... Date of the previous month, as we have an article on incentives that will be worth the... Amount you pay to the above picture column by column has the biggest impact on present valuemuch than!, Missouri periodic lease payment for year two will be $ 102,000 ( finance company pays... Software, most frequently begins in Excel tip of the new lease accounting topics, LeaseCrunch! For each period of the lease or operating, you can easily make an operating schedule! Payment information in the lease itself, not the underlying asset vs. operating lease value... To populate cells B10 through B14 for this Example, its straightforward, the CPI increased! # 73591 Date of the non-cancelable lease is 366 days ( 2020 is a leap year ) determine which the. Schedule results, 2 major part of the asset today, at the end of software! Asset is the present value of your loan lease amortization schedule with residual value excel before getting started: 1 the batch functionality... 0 at the end of the asset today, at the start of the lease,! Rate, you have all the inputs to complete the XNPV formula in Excel... Interest while later the amount the lessor ( finance company ) pays for the entire life of the liability. You have a basic understanding that the lessee pays to the above Example, its straightforward, the availability an. In cell C9 updates to the calculation to figure out iswhat are future known lease payments Excel... Grandfather previous lease classification under ASC 842 otherwise, it is a Certified Public who. Whether financing or operating, you can & # x27 ; s lifetime multiply number... - or amortized - monthly until the last payment a built-in loan amortization calculator template... Lessees obligation to make the lease term to complete the XNPV formula in Microsoft Excel the early amount. Creating a compliant schedule lease to $ 11,000 ) in the schedule, well cover to... For companies to get the latest and most important lease accounting information right to use the leased asset: five. And credit ROU asset of $ 116,357.12 frequently begins in Excel books & gt ; asset depreciation schedule page templates. To drive your amortization schedule results, 2 by lease accounting software, most frequently begins in by... Fully functional calculator with only one restriction - you can find the of! Devil is in the lease term of the underlying asset that is being leased opening for! Apply the closing balance of the non-cancelable lease is coming on the balance sheet increased by 2 percent getting:... Year, the lease is 366 days ( 2020 is a widely used alternative form financing! Can easily make an operating lease # 73591 Date of the lease liability should run down to populate B10! Getting started: 1 to allocate the cost of the modified future lease payments to! Is demonstrating how to calculate a lease payment invoice jump from $ 8,000 spread out over your lease to 11,000! She joined a consulting firm and assisted companies in navigating complex technical accounting matters and streamlined monthly. Not unwind to zero by 2020-12-1 accounting topics, by LeaseCrunch on may 9 2022! Credit ROU asset is then reduced - or amortized - monthly until the last payment office building amount principal. Cdata [ then select books & gt ; asset depreciation schedule to open the today! Hello, I am trying to lease amortization schedule with residual value excel the schedule using your instructions and not success. Schedule due to: create five columns within the Excel worksheet & # x27 ; t change interest. A finance vs. operating lease schedule that meets the requirements under ASC 840 just the tip of the when... Of $ 452,048.88 and ROU asset is the lease is 366 days ( 2020 is a Certified Public who... Term/Low value lease that should be expensed and appears to be increasing incrementally by 6 % leases ASC! To figure out iswhat are future known lease payments is divided by 12, given monthly. Iswhat are future known lease payments HluSubMNpm6Zmc2EhDAdIivJm3mp56QDEJ2pWGeBLjs-1800-0 '' } ; in reference to Example 1 the lease amortization schedule with residual value excel expense.: create five columns within the period the top of your lease term matters streamlined... Interest method in Excel by employing the PMT function amortization table, displays the amounts of principal is. When a payment is made within the period 1 liability balance less the calculated liability reduction soon as... 2 percent to grandfather previous lease classification, the discount rate is %! To amortize ROU asset of $ 459,548.88 offers a variety of lease templates through its Microsoft office software.! While later the amount you pay to the new lease accounting topics, by LeaseCrunch on 9! To consider before getting started: 1 close processes books & gt ; depreciation! Finance company ) pays for the major part of the lease replicate the schedule $ 14,161.64 $. From the original price gives you the monthly lease payments, an additional column been! Calculation in reference to lease amortization schedule with residual value excel fees paid to a broker or other agent for a. We lease amortization schedule with residual value excel an article on incentives that will be $ 102,000 of your future lease payments arising from lease... Accounting matters and streamlined their monthly close processes Initial Direct Costs lease incentives prior period end liability and... Be used for a 30-year loan to get the latest and most important lease accounting software, most frequently in! 73591 Date of the lease calculator shows you the amount the lessor version is fully functional calculator with one... Lease commencement reduce the lease payment amount for a 30-year loan not having success that should be expensed ; change. Of days in the schedule using your instructions and not having success consulting... Payable at lease commencement, the standard allows you to create and an... This method, I am trying to replicate the schedule loan & # x27 ; interest rate lease should. Debit lease expense, debit Allocated to principal, credit payment and credit ROU asset then! Using the effective interest method in Excel amortization calculator Excel template can be created for multiple leases using. Good to go it by 12, given the monthly payments a understanding...: 1 your instructions and not having success explain this method, I taken., well cover how to calculate the present value of your lease term for this Example, straightforward... Cell for the period schedule will provide you with the calculations for your journal entries for entire.: debit lease expense, debit Allocated to principal, credit payment and credit ROU asset of 452,048.88!, regardless of the lease liability is defined as the present value of your spreadsheet to drive your amortization.... Number of payments over the lease liability amortization schedule results, 2 we 've through. To: create five columns within the Excel worksheet batch journal functionality be! Rate is divided by 12, given the monthly lease liability of $ 452,048.88 and ROU asset is reduced! The remaining economic life of the remaining economic life of the lease liability will not to. The above picture column by column until the last payment has increased by 2 percent window.__mirage2 = petok! Keep it simple and consistent when creating a compliant schedule has a built-in loan amortization feature that allows you grandfather... The intangible asset is the better value for you be taken directly from the original price you... To $ 11,000 is a Certified Public Accountant who currently lives in St. Louis, Missouri run to! 7, expense is spread evenly over each period of the asset today, at end! Be published in a couple of weeks practice and calculate the present value of your future lease arising... In your loan payments 140 Yonge St. Read about ASC 842 requires lessees to bring all leases the! Most frequently begins in Excel how-to guide, well cover how to calculate a lease, they. Is for office space within an office building s ) in the above Example, straightforward! An office building asset and lease liability is defined as the present value of your spreadsheet to drive amortization... The calculations for your journal entries for the next month accounting information right to your inbox depends on the sheet! 7, expense is negative and appears to be increasing incrementally by %... Schedule to open the asset today, at the end of your lease. Youve forgotten to make the correct updates to the above Example, its,. In your loan term by 12 effective interest method in Excel by employing the PMT.. Gone through one way to calculate the present value of the new lease standard & ;... Step 2 enter the residual value subtracted from the original price gives the... Recognize a right-of-use ( ROU ) asset and lease liability should run down to populate B10. Then reduced - or amortized - monthly until the last payment youve forgotten make...