Hire Purchase & Borrowing Cost Concept

    Hire Purchase & Borrowing Cost Concept

Hire Purchase

Meaning of Hire Purchase: Hire purchase is an arrangement for buying Capital Assets, where the buyer makes an initial down payment and pays the balance with interest in installments. Title of the Asset Transfer to Buyer on Payment of the last Instalment. 

In Simple Word: Taking Loan for Buying Capital Asset.


For Example Emil Purchase Car for Business purposes with Hire Purchase Loan

If Capital Assets are Purchased first you need to get Tax Invoice.

In Tax invoice

Cost Price (Including GST)

$78000

Deposit

$5000

Amount due on Delivery

(78000-5000)

$73000

Term

60 Months

Loan Amount (including Borrowing Cost)

$73689

Total Interest

$11853.60

Repayment

$1035.71

Establishment Fees

$450

Inspect Report Fee

$150

Red Book Vital Inspection

$89

Total Borrowing Cost

(450+150+89)

$689

Loan Taken Date:

02/03/2022


Now open Hire Purchase Reconciliation Excel Sheet

In that fill the following Details

Amount Borrowed

$73689

Payment Frequency

Monthly

No. of Payment

60

Payment Per Period

$1035.71

Starting Date

(First Payment or Loan Taken Date)

02/03/2022

Excel Formula 

=Rate (Period, -Payment Per Period, Amount Borrowed) *12 Months

Excel Formula Application

=Rate (60, -1035.71,73689) *12


In Worksheet, it will show the interest rate automatically 

Now Type that Interest Rate in Excel under Annual Interest Rate: 4.7457% 

Now in Excel schedule, it calculates and shows the result.


Explanation

Total Cost as per Invoice

Cost of Car

$70909.09

GST

$7090.91

Total Cost

$78000



For Luxury Car as per financial year maximum $60733 (Gross) only allowed.

Cost

(Depreciation allowed portion)

$55211.82

GST

(GST allowed to Claim)

$5521.18

Maximum 

$60733


Particular

Debit

Credit

MV at Cost

$55211.82


GST Paid       

$5521.18


MV at Cost (Excluding Luxury Car Limit)

–No Depreciation allowed portion

-No GST Credit for this portion

$17267


HP Loan


$73000

Bank


$5000

Amortization of Borrowing Cost

$689


HP Loan


$689

Total

$78689

$78689


Unexpired Charges

$11853.60


To HP Loan


$11853.60




HP Loan Interest

$1147.99


To Unexpired Charges


$1147.99




HP Loan 

$4142.84


To Bank


$4142.84


HP Loan Balance in Balance Sheet at the Year End

HP Loan

81399.74

Unexpired Charges

(10705.61)

Net Amount

(It should Match with Excel Workings)

70694.15

Borrowing Cost

Borrowing Cost can’t able to claim as full Expenditure, it should be amortized.

Borrowing Cost of Loan write off Over the year of

‘Loan Repaid 

Or                                  Whichever is Earlier

5 Years’


Date of Borrowing

02/03/2022


Final Day of this financial Year

30/06/2022


Total Borrowing Cost

$689



How Borrowing cost will be calculated?

  1. Borrowing cost $689

  2. No of Days in FY 2022 From 02/03/2022 to 30/06/2022 🡺 120 Days.

  3. No of Days Between 02/03/2022 to 30/06/2026 🡺 1580 Days

  4. No of Days in a year 🡺 365 Days

Calculation

($689/1580 Days) X 120 Days = $52.32

($689/1580 Days) X 365 Days = $159.17

For Year End

Amortized to P&L

Balance in Balance Sheet



$689

30/06/2022

$52.32

$636.68

30/06/2023

$159.17

$477.51

30/06/2024

$159.17

$318.34

30/06/2025

$159.17

$159.17

30/06/2026

$159.17

$0

Balloon Payment Means

A Balloon Payment is when you agree to pay a one-time, lump-sum amount to your lending institution at the end of the loan's term. You will only pay interest and a fraction of the principal because you will be required to pay a lump amount at the conclusion of the loan.