{"id":2707,"date":"2025-02-19T00:27:41","date_gmt":"2025-02-19T00:27:41","guid":{"rendered":"https:\/\/sheets.market\/?p=2707"},"modified":"2025-02-19T00:30:39","modified_gmt":"2025-02-19T00:30:39","slug":"kredit-und-hypothekenberechnungen","status":"publish","type":"post","link":"https:\/\/sheets.market\/de\/loan-and-mortgage-calculations\/","title":{"rendered":"Kredit- und Hypothekenberechnungen in Excel: So verwenden Sie PMT- und Tilgungspl\u00e4ne"},"content":{"rendered":"\n<p>When it comes to managing loans and mortgages, having a clear understanding of how to calculate payments and track the progress of a loan is crucial for both financial planners and borrowers. Fortunately, Excel offers powerful tools like the <strong>PMT function<\/strong> and <strong>Amortization Schedules<\/strong> that can simplify this process. In this comprehensive guide, we\u2019ll walk you through everything you need about loan and mortgage calculations in Excel, from understanding the basic concepts to implementing these functions with practical, real-life examples.<\/p>\n\n\n\n<p>By the end of this article, you\u2019ll have actionable insights to handle your calculations, improve your financial forecasting, and gain confidence in creating detailed amortization schedules.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Understanding Loan and Mortgage Calculations<\/h2>\n\n\n\n<p>Before diving into Excel functions, let\u2019s first understand the basics. A loan or mortgage is a financial agreement where a borrower agrees to repay a sum of money with interest over a specified period. The total amount that needs to be repaid will consist of the principal (the original loan amount) plus interest.<\/p>\n\n\n\n<p>To manage loans efficiently, it\u2019s essential to break down the repayment process into periodic payments, where amortization schedules come into play. An <strong>amortization schedule<\/strong> is a detailed table of loan payments showing how much of each payment goes toward interest and how much goes toward the principal balance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why Excel is a Game-Changer for Loan and Mortgage Calculations<\/h2>\n\n\n\n<p><a href=\"https:\/\/sheets.market\/2024\/07\/19\/financial-model-in-excel\/\"><strong>Excel is more than just a spreadsheet tool<\/strong><\/a>\u2014it\u2019s a powerful financial calculator. With built-in functions like PMT (Payment), IPMT (Interest Payment), and PPMT (Principal Payment), you can quickly calculate monthly payments, interest, and principal breakdowns.&nbsp;<\/p>\n\n\n\n<p>Additionally, creating an amortization schedule in Excel allows you to visualize how your loan balance decreases over time and how much interest you\u2019ll pay over the life of the loan.<\/p>\n\n\n\n<p>This level of detail is essential for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Budgeting and financial planning<\/li>\n\n\n\n<li>Comparing loan options<\/li>\n\n\n\n<li>Understanding the long-term cost of borrowing<\/li>\n\n\n\n<li>Making informed decisions about prepayments or refinancing<\/li>\n<\/ul>\n\n\n\n<p>Let\u2019s start by exploring the PMT function and then move on to building a comprehensive amortization schedule.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The PMT Function: A Quick Overview<\/h2>\n\n\n\n<p>The PMT function in Excel is your go-to tool for calculating the periodic payment for a loan or mortgage. It considers the loan amount, interest rate, and loan term to determine how much you\u2019ll need to pay each period (usually monthly).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">PMT Function Syntax<\/h3>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXf_x-AWoVveV-_EIn3scw9_SDE5h-4AMrTrk2YWZWH60_Sckks8D2n-z1AFlqD4Xvpm490tGaRZS5mBYoWaEx2_Y6eAfhyS4DGGpugxTpMlqFKUgYrABm57qIFWmFQJi4axklFEeQ?key=aPICAfMr8ZMUthzioeZai__k\" alt=\"PMT function syntax\" style=\"width:840px;height:auto\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>rate<\/strong>: The interest rate for each period. For a monthly payment, divide the annual interest rate by 12.<\/li>\n\n\n\n<li><strong>nper<\/strong>: The total number of payments. For a 30-year mortgage, this would be 360 (30 years \u00d7 12 months).<\/li>\n\n\n\n<li><strong>pv<\/strong>: The present value or the total loan amount.<\/li>\n\n\n\n<li><strong>[fv]<\/strong>: (Optional) The future value or cash balance after the last payment. For loans, this is typically 0.<\/li>\n\n\n\n<li><strong>[type]<\/strong>: (Optional) When payments are due. Use 0 for end-of-period payments (default) or 1 for beginning-of-period payments.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Example: Calculating a Monthly Mortgage Payment<\/h3>\n\n\n\n<p>Let\u2019s say you\u2019re taking out a $300,000 mortgage with a 4% annual interest rate and a 30-year term. Here\u2019s how you\u2019d calculate the monthly payment:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open Excel and enter the following values in cells:\n<ol class=\"wp-block-list\">\n<li>Loan Amount (PV): $300,000 (Cell A1)<\/li>\n\n\n\n<li>Annual Interest Rate: 4% (Cell A2)<\/li>\n\n\n\n<li>Loan Term: 30 years (Cell A3)<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Convert the annual interest rate to a monthly rate and the loan term to months:\n<ol class=\"wp-block-list\">\n<li>Monthly Interest Rate: =A2\/12 (Cell B2)<\/li>\n\n\n\n<li>Number of Payments: =A3*12 (Cell B3)<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Use the PMT function to calculate the monthly payment:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXd6RaBFMbR9e2y58Sf18AY3S1s-c9z2qS0iU4a6qKqB1M26zLKSfTKU-R39r2vW0HQ4td5MP7D7OCGIzCi81C34Pb56drHHXXcGrHg4roGMUIEk8OhOZDond9R9lKR6OKW4fL0Ugw?key=aPICAfMr8ZMUthzioeZai__k\" alt=\"PMT function\" style=\"width:840px;height:auto\" \/><\/figure>\n\n\n\n<p>The result will be <strong>$1,432.25<\/strong>, which is your monthly mortgage payment.<\/p>\n\n\n\n<p><strong>Pro Tip:<\/strong> Always use a negative sign for the loan amount (pv) to ensure the result is positive, as it represents an outgoing payment.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How Amortization Schedules Work<\/h2>\n\n\n\n<p>An <strong>amortization schedule<\/strong> allows you to break down each payment over the life of the loan into two components: interest and principal. The interest portion decreases over time while the principal portion increases. The amount of each payment that goes toward the interest is calculated by multiplying the outstanding loan balance by the monthly interest rate.<\/p>\n\n\n\n<p>The general formula for calculating the interest payment in a given period is:<\/p>\n\n\n\n<p><strong>Interest Payment = Outstanding Loan Balance \u00d7 Monthly Interest Rate<\/strong><\/p>\n\n\n\n<p>The principal payment for the period can then be found by subtracting the interest payment from the total payment:<\/p>\n\n\n\n<p><strong>Principal Payment = Total Payment &#8211; Interest Payment<\/strong><\/p>\n\n\n\n<p>This process continues until the entire loan is paid off.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creating an Amortization Schedule in Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcJjtnZ0SfQVfusGS9WYG5REtWFj-GbS-c-7WaxdT3wd_fCkM_f3JlAfBv3Kz11JIEQkKntXu_s_h3nL2vR7_qEK_EsnFRweDkPrQPLn4t3chW-zepJO9S1aWs7t2YFQhIfQYahVQ?key=aPICAfMr8ZMUthzioeZai__k\" alt=\"amortization schedule in excel\" \/><\/figure>\n\n\n\n<p>Now that you understand the theory behind loan and mortgage calculations let&#8217;s walk through the steps to create an amortization schedule in Excel.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step-by-Step Guide for Creating an Amortization Schedule<\/strong><\/h4>\n\n\n\n<p>Let\u2019s use the same example: A $200,000 mortgage at 5% interest for 30 years.<\/p>\n\n\n\n<p><strong>Step 1: Set Up Your Excel Spreadsheet<\/strong>&nbsp;<\/p>\n\n\n\n<p>Start by organizing your Excel sheet with the following columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Period<\/strong>: The payment number (1, 2, 3, etc.)<\/li>\n\n\n\n<li><strong>Payment<\/strong>: The total payment (calculated using the PMT function)<\/li>\n\n\n\n<li><strong>Interest<\/strong>: The interest paid in the current period<\/li>\n\n\n\n<li><strong>Principal<\/strong>: The amount of the payment applied to the principal<\/li>\n\n\n\n<li><strong>Balance<\/strong>: The remaining balance of the loan<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 2: Calculate the Monthly Payment Using PMT<\/strong><\/p>\n\n\n\n<p>In cell B2, enter the formula for the monthly payment:<\/p>\n\n\n\n<p><strong>=PMT(5%\/12, 360, -200000)<\/strong><\/p>\n\n\n\n<p>This will return the monthly payment of $1,073.64. You can copy this value down the entire column.<\/p>\n\n\n\n<p><strong>Step 3: Calculate the Interest and Principal for Each Payment Period<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Interest Payment<\/strong> (Cell C2): In cell C2, enter the formula to calculate the interest for the first period:<br><strong>=B2 * 5%\/12<\/strong><\/li>\n\n\n\n<li><strong>Principal Payment<\/strong> (Cell D2): In cell D2, enter the formula to calculate the principal paid in the first period:<br><strong>=B2 &#8211; C2<\/strong><\/li>\n\n\n\n<li><strong>Remaining Balance<\/strong> (Cell E2): In cell E2, enter the formula to calculate the balance after the first payment:<br><strong>=200000 &#8211; D2<\/strong><\/li>\n<\/ul>\n\n\n\n<p><strong>Step 4: Fill Down for the Remaining Periods<\/strong><\/p>\n\n\n\n<p>For each subsequent row, adjust the formulas to reflect the updated balance.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Interest Payment<\/strong> (Cell C3 and below):<br><strong>=E2 * 5%\/12<\/strong><\/li>\n\n\n\n<li><strong>Principal Payment<\/strong> (Cell D3 and below):<br><strong>=B3 &#8211; C3<\/strong><\/li>\n\n\n\n<li><strong>Remaining Balance<\/strong> (Cell E3 and below):<br><strong>=E2 &#8211; D3<\/strong><\/li>\n<\/ul>\n\n\n\n<p>After you fill down the formulas for all periods (360 months in this case), you\u2019ll have a complete amortization schedule.<\/p>\n\n\n\n<p><strong>Pro Tip:<\/strong> After the final payment, the remaining balance should be reduced to zero.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Sample Amortization Schedule (First Few Payments)<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Period<\/strong><\/td><td><strong>Payment<\/strong><\/td><td><strong>Interest<\/strong><\/td><td><strong>Principal<\/strong><\/td><td><strong>Remaining Balance<\/strong><\/td><\/tr><tr><td>1<\/td><td>1073.64<\/td><td>833.33<\/td><td>240.31<\/td><td>199,759.69<\/td><\/tr><tr><td>2<\/td><td>1073.64<\/td><td>832.99<\/td><td>240.65<\/td><td>199,519.04<\/td><\/tr><tr><td>3<\/td><td>1073.64<\/td><td>832.66<\/td><td>241.00<\/td><td>199,278.04<\/td><\/tr><tr><td>4<\/td><td>1073.64<\/td><td>832.32<\/td><td>241.32<\/td><td>199,036.72<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>As you can see, the interest decreases slightly with each payment while the principal increases.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Advanced Tips for Loan and Mortgage Calculations in Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdp_pGNhaFDiuwcUigeAjhKKuJUxC-bnUThEWatfFJuCtZOsa7GaV7K9iX5f-SBf_4MKtCauaHlwHZkhGBALwxSE-QuKxuq2CF6MeQaKwwDLnvUGkOj99o_iva0yW_MIwpyqO2i?key=aPICAfMr8ZMUthzioeZai__k\" alt=\"Loan and Mortgage Calculations in Excel\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Extra Payments<\/h3>\n\n\n\n<p>If you plan to make extra payments, you can adjust your amortization schedule to account for them. Simply add a column for <strong>Extra Payment<\/strong> and subtract it from the <strong>Ending Balance<\/strong>.<\/p>\n\n\n\n<p>For example, if you pay an extra $200 towards the principal each month, you can reduce the principal amount each period, reducing the interest and shortening the loan term. The formula for new loan balance:&nbsp;<\/p>\n\n\n\n<p><strong>=previous_balance &#8211; extra_payment<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Variable Interest Rates<\/h3>\n\n\n\n<p>For <a href=\"https:\/\/corporatefinanceinstitute.com\/resources\/commercial-lending\/adjustable-rate-mortgage-arm\/\"><strong>adjustable-rate mortgages (ARMs)<\/strong><\/a>, you can modify your schedule to reflect changes in the interest rate. Use conditional formulas or manually update the rate as needed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Visualizing Data<\/h3>\n\n\n\n<p>Use Excel\u2019s charting tools to create visual representations of your amortization schedule. For example, you can make a line chart to show how your payments&#8217; principal and interest portions change over time.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Use the NPER Function for Loan Term Calculations<\/h3>\n\n\n\n<p>If you need to calculate how long it will take to pay off a loan given a specific payment amount, the <strong>NPER<\/strong> function is handy.&nbsp;<\/p>\n\n\n\n<p>Formula:&nbsp;<\/p>\n\n\n\n<p><strong>=NPER(interest_rate\/12, -payment, loan_amount)<\/strong><\/p>\n\n\n\n<p>This function returns the number of periods (months or years) needed to pay off the loan.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Advanced Conditional Formatting for Better Visuals<\/h3>\n\n\n\n<p>Conditional formatting can help you visually track loan balances, interest, and principal payments.<\/p>\n\n\n\n<p>For example, you can set a color scale highlighting months when interest payments are exceptionally high, showing the point in the schedule where you are paying down the principal more quickly.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What-If Scenarios with Data Tables<\/h3>\n\n\n\n<p>Use Data Tables in Excel to explore how changing variables like the interest rate or loan term affects your monthly payment. Select the range of values for the variable (e.g., different interest rates) and set up a one-variable or two-variable data table to see how these changes impact your overall loan cost.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Loan Comparison<\/h3>\n\n\n\n<p>Create a comparison model for different loans with various terms and interest rates by using Excel\u2019s <strong>SUMPRODUCT<\/strong> function to calculate total payments or the total cost of loans over time.<\/p>\n\n\n\n<p>Formula:&nbsp;<\/p>\n\n\n\n<p><strong>=SUMPRODUCT(payment_array, loan_term_array)<\/strong><\/p>\n\n\n\n<p>This will give you a more comprehensive view of your loan options.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">XIRR Function for Non-Periodic Payments<\/h3>\n\n\n\n<p>If your payments are irregular (e.g., not monthly), you can use the <strong>XIRR<\/strong> function to calculate the effective interest rate on your loan.<\/p>\n\n\n\n<p>Formula:&nbsp;<\/p>\n\n\n\n<p><strong>=XIRR(values, dates)<\/strong><\/p>\n\n\n\n<p>This is particularly useful for loans where the payments are not fixed or made at irregular intervals.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Loan Prepayment Effects<\/h3>\n\n\n\n<p>To understand the impact of paying off a loan early, you can use Excel to model how your remaining balance, interest, and total payments change. Add a column for prepayments, and adjust the remaining balance after each payment period to reflect early payments.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Use Goal Seek for Payment Adjustments<\/h3>\n\n\n\n<p>Goal Seek can help determine how much you must pay monthly to achieve a certain loan balance in several periods.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to <strong>Data &gt; What-If Analysis &gt; Goal Seek<\/strong>.<\/li>\n\n\n\n<li>Set the goal to be your target loan balance, and the &#8220;changing cell&#8221; will be the monthly payment.<\/li>\n<\/ul>\n\n\n\n<p>These advanced tips will help you fine-tune your mortgage and loan calculations in Excel, giving you more insights into your financial situation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Common Mistakes to Avoid<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Incorrect Interest Rate Conversion<\/strong>: Always convert the annual interest rate to the appropriate period (e.g., monthly for monthly payments).<\/li>\n\n\n\n<li><strong>Ignoring Loan Fees<\/strong>: Don\u2019t forget to include upfront fees (e.g., origination fees) in your calculations. These can be added to the loan amount or subtracted from the present value.<\/li>\n\n\n\n<li><strong>Overlooking Payment Frequency<\/strong>: Ensure that the payment frequency (monthly, biweekly, etc.) matches the interest rate and loan term.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Take Control of Your Loans with Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXccrGaYjzVsa5AmEjLL07WsMqP4Ord2A5eKvKqzue9fv6cUU838-aA2pkWbmjgICbnGIfc5W21nbmbM-n9BdhV08OA3Qh-FYYXsolfSQDotEeAnEcjcoFH6nYzNhMNJAA_gnXMx_w?key=aPICAfMr8ZMUthzioeZai__k\" alt=\"sheets.market homepage\" \/><\/figure>\n\n\n\n<p>Understanding how to calculate loan payments and create amortization schedules is a crucial skill, whether you&#8217;re managing personal debt, advising clients, or running financial planning services. By mastering Excel\u2019s PMT function and creating detailed amortization schedules, you can efficiently manage loan payments and gain deeper insights into how your debt is structured over time.<\/p>\n\n\n\n<p>For those who want to skip the manual work and improve accuracy, SHEETS.MARKET offers a variety of templates to streamline your loan and mortgage calculations.<\/p>\n\n\n\n<p>Ready to simplify your loan calculations and access more financial resources? Explore the <a href=\"https:\/\/sheets.market\/excel-financial-models\/\"><strong>templates on SHEETS.MARKET<\/strong><\/a> and take your financial planning to the next level. You can also <a href=\"https:\/\/www.linkedin.com\/company\/sheets-market\/\"><strong>connect with us on LinkedIn<\/strong><\/a> for more tips, tools, and resources to help you stay ahead of the curve.<\/p>\n\n\n\n<p>Start using the right tools today and gain complete control over your financial future!<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Bei der Verwaltung von Krediten und Hypotheken ist es sowohl f\u00fcr Finanzplaner als auch f\u00fcr Kreditnehmer entscheidend, genau zu wissen, wie man Zahlungen berechnet und den Fortschritt eines Kredits verfolgt. Gl\u00fccklicherweise bietet Excel leistungsstarke Tools wie die PMT-Funktion und Tilgungspl\u00e4ne, die diesen Prozess vereinfachen k\u00f6nnen. In diesem umfassenden Leitfaden gehen wir<\/p>","protected":false},"author":0,"featured_media":2708,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[],"class_list":["post-2707","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-financial-models"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Loan and Mortgage Calculations in Excel: How to Use PMT &amp; Amortization Schedules - Sheets.Market<\/title>\n<meta name=\"description\" content=\"Master Loan and Mortgage Calculations in Excel with PMT, IPMT, and amortization schedules for accurate financial planning and insights.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sheets.market\/de\/kredit-und-hypothekenberechnungen\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Loan and Mortgage Calculations in Excel: How to Use PMT &amp; Amortization Schedules - Sheets.Market\" \/>\n<meta property=\"og:description\" content=\"Master Loan and Mortgage Calculations in Excel with PMT, IPMT, and amortization schedules for accurate financial planning and insights.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sheets.market\/de\/kredit-und-hypothekenberechnungen\/\" \/>\n<meta property=\"og:site_name\" content=\"Sheets.Market\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-19T00:27:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-19T00:30:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sheets.market\/wp-content\/uploads\/2025\/02\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1735\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"10\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"Loan and Mortgage Calculations in Excel: How to Use PMT &amp; Amortization Schedules\",\"datePublished\":\"2025-02-19T00:27:41+00:00\",\"dateModified\":\"2025-02-19T00:30:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/\"},\"wordCount\":1798,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sheets.market\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg\",\"articleSection\":[\"Financial Models\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/\",\"url\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/\",\"name\":\"Loan and Mortgage Calculations in Excel: How to Use PMT &amp; Amortization Schedules - Sheets.Market\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sheets.market\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg\",\"datePublished\":\"2025-02-19T00:27:41+00:00\",\"dateModified\":\"2025-02-19T00:30:39+00:00\",\"description\":\"Master Loan and Mortgage Calculations in Excel with PMT, IPMT, and amortization schedules for accurate financial planning and insights.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sheets.market\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/sheets.market\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg\",\"width\":2560,\"height\":1735,\"caption\":\"Loan and Mortgage Calculations\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sheets.market\\\/loan-and-mortgage-calculations\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sheets.market\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Loan and Mortgage Calculations in Excel: How to Use PMT &amp; Amortization Schedules\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sheets.market\\\/#website\",\"url\":\"https:\\\/\\\/sheets.market\\\/\",\"name\":\"Sheets.Market\",\"description\":\"Financial Models and Business Plans\",\"publisher\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sheets.market\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sheets.market\\\/#organization\",\"name\":\"Sheets.Market\",\"url\":\"https:\\\/\\\/sheets.market\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/sheets.market\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sheets.market\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/Color-logo-no-background.png?wsr\",\"contentUrl\":\"https:\\\/\\\/sheets.market\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/Color-logo-no-background.png?wsr\",\"width\":1181,\"height\":136,\"caption\":\"Sheets.Market\"},\"image\":{\"@id\":\"https:\\\/\\\/sheets.market\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Kredit- und Hypothekenberechnungen in Excel: So verwenden Sie PMT- und Tilgungspl\u00e4ne - Sheets.Market","description":"Beherrschen Sie Kredit- und Hypothekenberechnungen in Excel mit PMT, IPMT und Tilgungspl\u00e4nen f\u00fcr eine genaue Finanzplanung und Einblicke.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sheets.market\/de\/kredit-und-hypothekenberechnungen\/","og_locale":"de_DE","og_type":"article","og_title":"Loan and Mortgage Calculations in Excel: How to Use PMT &amp; Amortization Schedules - Sheets.Market","og_description":"Master Loan and Mortgage Calculations in Excel with PMT, IPMT, and amortization schedules for accurate financial planning and insights.","og_url":"https:\/\/sheets.market\/de\/kredit-und-hypothekenberechnungen\/","og_site_name":"Sheets.Market","article_published_time":"2025-02-19T00:27:41+00:00","article_modified_time":"2025-02-19T00:30:39+00:00","og_image":[{"width":2560,"height":1735,"url":"https:\/\/sheets.market\/wp-content\/uploads\/2025\/02\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"10\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/#article","isPartOf":{"@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/"},"author":{"name":"","@id":""},"headline":"Loan and Mortgage Calculations in Excel: How to Use PMT &amp; Amortization Schedules","datePublished":"2025-02-19T00:27:41+00:00","dateModified":"2025-02-19T00:30:39+00:00","mainEntityOfPage":{"@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/"},"wordCount":1798,"commentCount":0,"publisher":{"@id":"https:\/\/sheets.market\/#organization"},"image":{"@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/#primaryimage"},"thumbnailUrl":"https:\/\/sheets.market\/wp-content\/uploads\/2025\/02\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg","articleSection":["Financial Models"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sheets.market\/loan-and-mortgage-calculations\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/","url":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/","name":"Kredit- und Hypothekenberechnungen in Excel: So verwenden Sie PMT- und Tilgungspl\u00e4ne - Sheets.Market","isPartOf":{"@id":"https:\/\/sheets.market\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/#primaryimage"},"image":{"@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/#primaryimage"},"thumbnailUrl":"https:\/\/sheets.market\/wp-content\/uploads\/2025\/02\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg","datePublished":"2025-02-19T00:27:41+00:00","dateModified":"2025-02-19T00:30:39+00:00","description":"Beherrschen Sie Kredit- und Hypothekenberechnungen in Excel mit PMT, IPMT und Tilgungspl\u00e4nen f\u00fcr eine genaue Finanzplanung und Einblicke.","breadcrumb":{"@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sheets.market\/loan-and-mortgage-calculations\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/#primaryimage","url":"https:\/\/sheets.market\/wp-content\/uploads\/2025\/02\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg","contentUrl":"https:\/\/sheets.market\/wp-content\/uploads\/2025\/02\/closeup-hands-using-computer-laptop-with-screen-showing-analysis-data-scaled.jpg","width":2560,"height":1735,"caption":"Loan and Mortgage Calculations"},{"@type":"BreadcrumbList","@id":"https:\/\/sheets.market\/loan-and-mortgage-calculations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sheets.market\/"},{"@type":"ListItem","position":2,"name":"Loan and Mortgage Calculations in Excel: How to Use PMT &amp; Amortization Schedules"}]},{"@type":"WebSite","@id":"https:\/\/sheets.market\/#website","url":"https:\/\/sheets.market\/","name":"Tabellen.Markt","description":"Finanzmodelle und Gesch\u00e4ftspl\u00e4ne","publisher":{"@id":"https:\/\/sheets.market\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sheets.market\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/sheets.market\/#organization","name":"Tabellen.Markt","url":"https:\/\/sheets.market\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/sheets.market\/#\/schema\/logo\/image\/","url":"https:\/\/sheets.market\/wp-content\/uploads\/2024\/06\/Color-logo-no-background.png?wsr","contentUrl":"https:\/\/sheets.market\/wp-content\/uploads\/2024\/06\/Color-logo-no-background.png?wsr","width":1181,"height":136,"caption":"Sheets.Market"},"image":{"@id":"https:\/\/sheets.market\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/posts\/2707","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/comments?post=2707"}],"version-history":[{"count":2,"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/posts\/2707\/revisions"}],"predecessor-version":[{"id":2711,"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/posts\/2707\/revisions\/2711"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/media\/2708"}],"wp:attachment":[{"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/media?parent=2707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/categories?post=2707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheets.market\/de\/wp-json\/wp\/v2\/tags?post=2707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}