Calculation Files - Excel Files (236)

Layout:

Apartments

Breakdown of Apartments Details of apartments
Details

Annual Rental Income-Expense-Mileage Tracking (Canada, Ontario) v2

This form has tax breakout for expenses set for Ontario tax rates. No Guarantees. I'm not an accountant. Please let me know if you find it useful. Credit where credit is due. The base template came from http://www.fastbusinessplans.com/business-templates/rental-income-expenses-spreadsheet.html This form has a tax breakdown for expenses determined for tax rates in Ontario. No commitments. I'm not an accountant. Please let me know if you find this helpful. Credit instead of credit is required. The master template came from http://www.fastbusinessplans.com/business-templates/rental-income-expenses-spreadsheet.html
Details

Annual Property Financials

This spreadsheet allows you to input your monthly income and expenses in and compiles it into an annual financial report. It also compiles the data into a schedule E form, so you can verify your numbers before submitting your taxes. This spreadsheet currently supports 7 properties but can be scaled as needed. This spreadsheet allows you to enter your monthly income and expenses and compile them into an annual financial report. It also compiles the data into a Schedule E form so you can verify your numbers before you file your taxes. This spreadsheet currently supports 7 properties but can be scaled as needed.
Details

Analysis Spreadsheet

Analysis Spreadsheet Analysis spreadsheet
Details

Analysis Of Syndication Versus JV

The file contains a basic comparison of JV investments versus syndications. The file contains a basic comparison of JV investments versus syndications.
Details

Amortization Table template

excel template for amortization Excel template for reduction
Details

Amortization Table

Simple fixed rate amortization table with a data table to calculate the decrease in loan payoff time with additional principal payments. A simple fixed rate amortization table with a data table for calculating the decrease during the loan provision with additional principal payments.
Details

Amort1.xlsx

Amortization of a 30-year loan, $200,000 initial balance, 5% APR. 30-year loan reduction, initial balance of $200,000, APR 5%.
Details

Amort1_Vel.xlsx

Amortization of 30 year mortgage, $200,000 initial balance, 5% APR, loan accelerated to 9.1 years by making a $15,000 additional principal payment once a year ("velocity banking"). 30-year mortgage reduction, $200,000 initial balance, APR 5%, the loan accelerated to 9.1 years by making an additional payment of $15,000 once a year ("fast banking").
Details

All Cash? 15 Year Loan? 30 Year Loan?

This is an attempt to study the financial impact of buying real estate with all cash, or buying real estate with 15 or 30 year loans. This is an attempt to study the financial impact of buying real estate in all cash, or buying real estate with 15 or 30 year loans.
Details
Showing 211-220 or 236

Calculation files - Excel Files (236)

Layout:

Apartments

Breakdown of Apartments Details of apartments
Details

Annual Rental Income-Expense-Mileage Tracking (Canada, Ontario) v2

This form has tax breakout for expenses set for Ontario tax rates. No Guarantees. I'm not an accountant. Please let me know if you find it useful. Credit where credit is due. The base template came from http://www.fastbusinessplans.com/business-templates/rental-income-expenses-spreadsheet.html This form has a tax breakdown for expenses determined for tax rates in Ontario. No commitments. I'm not an accountant. Please let me know if you find this helpful. Credit instead of credit is required. The master template came from http://www.fastbusinessplans.com/business-templates/rental-income-expenses-spreadsheet.html
Details

Annual Property Financials

This spreadsheet allows you to input your monthly income and expenses in and compiles it into an annual financial report. It also compiles the data into a schedule E form, so you can verify your numbers before submitting your taxes. This spreadsheet currently supports 7 properties but can be scaled as needed. This spreadsheet allows you to enter your monthly income and expenses and compile them into an annual financial report. It also compiles the data into a Schedule E form so you can verify your numbers before you file your taxes. This spreadsheet currently supports 7 properties but can be scaled as needed.
Details

Analysis Spreadsheet

Analysis Spreadsheet Analysis spreadsheet
Details

Analysis Of Syndication Versus JV

The file contains a basic comparison of JV investments versus syndications. The file contains a basic comparison of JV investments versus syndications.
Details

Amortization Table template

excel template for amortization Excel template for reduction
Details

Amortization Table

Simple fixed rate amortization table with a data table to calculate the decrease in loan payoff time with additional principal payments. A simple fixed rate amortization table with a data table for calculating the decrease during the loan provision with additional principal payments.
Details

Amort1.xlsx

Amortization of a 30-year loan, $200,000 initial balance, 5% APR. 30-year loan reduction, initial balance of $200,000, APR 5%.
Details

Amort1_Vel.xlsx

Amortization of 30 year mortgage, $200,000 initial balance, 5% APR, loan accelerated to 9.1 years by making a $15,000 additional principal payment once a year ("velocity banking"). 30-year mortgage reduction, $200,000 initial balance, APR 5%, the loan accelerated to 9.1 years by making an additional payment of $15,000 once a year ("fast banking").
Details

All Cash? 15 Year Loan? 30 Year Loan?

This is an attempt to study the financial impact of buying real estate with all cash, or buying real estate with 15 or 30 year loans. This is an attempt to study the financial impact of buying real estate in all cash, or buying real estate with 15 or 30 year loans.
Details
Showing 211-220 or 236