F. Tayari

Rank: 1634 / 5440

6 selected videos

Lesson 11 video 6: Project Evaluation with Loan (Borrowed Money) Using Excel Spreadsheet

There are four types of loan:

1. Balloon Payment Loan

2. Interest Only Loan

3. Constant Amortization Loan

4. Constant Payment Loan

In this video I use Excel spreadsheet to work on an example and explain the project evaluation with Constant Amortization Loan. I also show how to calculate the interest and principle portion of each payment.

I described the Balloon Payment, Interest Only, Constant Amortization, and Constant Amortization Loan loans in previous videos.

View more

Related topics : amortization loan calculator with balloon / calculating loan payments in excel

Lesson 11 video 5: Project Evaluation with Loan (Borrowed Money)

There are four types of loan:

1. Balloon Payment Loan

2. Interest Only Loan

3. Constant Amortization Loan

4. Constant Payment Loan

In this video I am going to explain the project evaluation with Constant Amortization Loan and how loan and borrowed money can affect the economics and profitability of the project. I also describe how to calculate the interest and principle portion of each payment.

In the next video I will use Excel spreadsheet for this example and I will show how we can utilize...

View more

Related topics : amortization loan calculator with balloon / calculating loan interest

Lesson 11 video 4: Constant Payment Loan, Interest and Principle

There are four types of loan:

1. Balloon Payment Loan

2. Interest Only Loan

3. Constant Amortization Loan

4. Constant Payment Loan

I am going to explain the Constant Amortization Loan in this video. And I will describe how to calculate the interest and principle portion of each payment.

In the next video I will work on an example and demonstrate how to evaluate a project with Constant Payment loan.

I described the Balloon Payment, Interest Only, and Constant Amortization loans in previous...

View more

Related topics : amortization loan calculator with balloon / calculating loan payments / calculating loan interest

Lesson 3 video 1: Calculating APR for a loan or mortgage

In this video I will explain how to calculate the Annual Percentage Rates (APR) of a loan or mortgage using return on investment techniques.

View more

Related topics : loan mortgage rate calculator

Lesson 11 video 3: Constant Amortization Loan

There are four types of loan:

1. Balloon Payment Loan

2. Interest Only Loan

3. Constant Amortization Loan

4. Constant Payment Loan

I am going to explain the Constant Amortization Loan in this video.

I described the Balloon Payment and Interest Only Loans in previous videos and I will explain the Constant Payment Loan in the next video.

View more

Related topics : loan amortization

Lesson 11 video 2: Balloon Payment Loan and Interest Only Loan

There are four types of loan:

1. Balloon Payment Loan

2. Interest Only Loan

3. Constant Amortization Loan

4. Constant Payment Loan (the most common one)

In this video I will explain the Balloon Payment Loan and Interest Only Loan. In the following videos I will describe the Constant Amortization Loan and Constant Payment Loan.

View more

Related topics : loan amortization