Excel Interest Rental formula worksheet and its properties. What can the Excel spreadsheet calculate? With the exception of the final ransom or maxicanon, the Excel spreadsheet has the same features as the online application. Download it for offline use. Download the file Interest Leasing with Excel: Calculation sheet Interest Leasing Excel Data to display in the application: As a rule, since it is a leasing, neither VAT nor other ancillary costs nor even a possible advance, since you do not pay interest on it: It makes sense! While we specify the amount, including a possible redemption, because the application plans to separate it and calculate the interest separately. For example: by specifying an amount of 30,000 euros and 3,000 redemptions, the application calculates the interest at 27,000 euros and separately at the 3,000 euros of the final repayment. is the one used by the Italian legislator, the company using the asset will record the leasing costs in the profit and loss account in accordance with the principle of jurisdiction, while in the liability accounts of the balance sheet the residual debt to the leasing company will be determined; The interest portion of a lease commission could be calculated by deducting from the total amount of periodic rent the portion attributable to the main portion. Sometimes you already know the amount of the two values and it is therefore enough to make a simple subtraction “interest share = total costs – main share”. However, in other situations, it is necessary to calculate the interest rate. It is necessary to multiply the interest rate of the loan by the capital remaining at the beginning of the period to which the periodic fees refer. Article 2(18) of Decree-Law No 262/2006 formulated Article 262/2006(7) and (8). 36, Legislative Decree No 223 of 2006, which contains provisions aimed at making the depreciation of land used by construction exempt from tax, and introduced into Article 36(7a). The new paragraph 7 of Article 36 provides that, for the purposes of calculating the deductible depreciation rates, the total cost of instrumental buildings less the costs of the areas occupied by the construction and those representing their relevance is to be incurred. The costs attributable to the aforementioned areas, in the event that they have not already been acquired independently of each other, correspond to the higher intermediate value: the main novelty compared to the original text of Legislative Decree No.

223 of 2006 is the removal of the obligation to determine the value of the area by means of an assessment assessment. The new paragraph 7-bis, Article 36, Dl n. 223 of 2006 aims to extend the tax treatment of the total costs of instrumental buildings to rents related to the rental of an instrumental building (which must therefore be taken into account for the purpose of deducting the same minus the part relating to the areas occupied by instrumental buildings). Just as paragraph 7 provides for the non-deductibility of depreciation shares of the land occupied by the construction or of the building acquired as land, the new Article 36(7)(a) provides, in a limited manner, for the non-deductibility of the share of the capital of the rents relating to the same land for instrumental buildings acquired under the financing contract, on which the instrument buildings covered by the lease are located. Circular No. 446 of the taxable amount of the regional tax on productive activities is determined by deducting from the amount of the jurisdictional rent for each tax period included in the duration of the finance lease the amount resulting from the division of the costs incurred by the conceding company by the number of days of the duration of the finance lease and the result by the number of days of the tax period is multiplied”. In the case of the commissioning of a leasing contract for the purchase of an instrumental building, it must be determined that the calculation of the Maxicanone or Maxirata and rental interest is particularly suitable for simulating a lease estimate that could go beyond that of financial charges. .