Question

In: Accounting

An Auto Finance Company (AFC) is doing business forlast 20 years and offers various financial products...

An Auto Finance Company (AFC) is doing business forlast 20 years and offers various financial products including finance lease, hire purchase and operating lease.

AFC takes postdated cheques from customers in advance and deposits with banks on due dates. AFC enters the realization date of all cheques in system on daily basis. Average numbers of daily deposited cheques are 700. Around 10% of deposited cheques gets returned unpaid. The unpaid cheques are deposited next day into bank. The AFC cannot switch to Direct Debit because of certain reasons

The AFC is following IFRS for accounting. The company follows the policy to round rental amount to zero decimal places. The rentals are amortized using annuity method. The company books income on monthly basis.

The AFC has extended a lease facility to a Ltd. company, the extracts of which are as under:


• Asset cost = 100,000

• Contract terms = 48 months

• Annual interest rate = 9%

• Re-payment frequency = Quarterly in Arrear

• RV = 10,000

• Down payment = 8,000

• Security deposit = 50,000

• Start day of the contract = 15th February, 2018

• Asset useful life = 60 months

• Rental numbers 9 to 16 should be double in amount as compared to rental numbers 1 to 8 (e.g. if rental numbers 1 to 8 are 5,000 each then rental numbers 9 to 16 should be 10,000 each)

• Use of XLS Goal Seek is prohibited for rental calculation


You are required to:

1. Determine the lease type according to IFRS definitions for both lessee and lessor. Please mention all criteria of IFRS and identify that which one is met and which one is not

2. Calculate periodic lease rentals

3. Based on point 2 above, prepare amortization schedules for AFC

4. Calculate the AFC’s achieved rate of return.

5. Prepare all accounting entries for AFC starting from contract signing till restructuring. Accounting entry must be with reference to a date

6. The AFC customer has defaulted after paying 2nd rental and now 5th rental is due. Customer has requested and AFC agreed to restructure the lease facility by increasing interest rate 1 % p.a. and recovering the interest overdue and penalty amount upfront. The company charges 20% p.a. penalty for overdue on actual days basis. Please workout the restructured rental amount, New Amortization schedule and the accounting treatment at restructuring this contract. Please keep the Zero rental or fix amount rental same as mentioned in the original scenario

Solutions

Expert Solution

1. Lease type as per IFRS

Lease is a contract which explains an agreement between two or more persons that creates enforceable rights and obligations for right to use an asset for the fixed period of time in exchange for the interest. There are mainly 2 types of lease as per the IFRS norms such as operating lease and finance lease (Brigham and Houston, 2009).

An operating lease is particularly attractive to those companies that consistently replace its machinery and need to use the equipment without buying the full amount. It is less costly and helpful for the company for the long term benefits without investing bulk of money (Harrison, 2008).

Finance lease is full payouts; it is non cancellable agreements in which the lessee is responsible for the maintenance, taxes and insurance . Financial lease is very much attracting those lenders who are looking for the tax benefits. For capital lease amortization is must be applied to pay both interest and principal .

There are some other types of lease such as capital lease, direct financing lease, first amendment lease full payout lease and net lease.

2. Calculate the periodic lease Rentals for 10th and 11th quarter

Quarter

Payment

Principal Paid

Interest Paid

Remaining Balance

1

$7,341.06

$4,581.06

$2,760.00

$87,418.94

2

$7,341.06

$4,718.49

$2,622.57

$82,700.45

3

$7,341.06

$4,860.05

$2,481.01

$77,840.40

4

$7,341.06

$5,005.85

$2,335.21

$72,834.55

5

$7,341.06

$5,156.02

$2,185.04

$67,678.53

6

$7,341.06

$5,310.70

$2,030.36

$62,367.83

7

$7,341.06

$5,470.03

$1,871.03

$56,897.80

8

$7,341.06

$5,634.13

$1,706.93

$51,263.67

9

$7,341.06

$5,803.15

$1,537.91

$45,460.52

10

$7,341.06

$5,977.24

$1,363.82

$39,483.28

11

$7,341.06

$6,156.56

$1,184.50

$33,326.72

12

$14682.12

$6,341.26

$999.80

$26,985.46

13

$14682.12

$6,531.50

$809.56

$20,453.96

14

$7,341.06

$6,727.44

$613.62

$13,726.52

15

$7,341.06

$6,929.26

$411.80

$6,797.26

16

$7,001.18

$6,797.26

$203.92

$0

Totals

$117,117.08

$92,000.00

$25,117.08

From the above, it has been found that, AFC has not been able to receive the 10th quarter and the 11th quarter money which has been adjusted in the 12 and 13th quarter by the lessee . The total amount paid during the 12 and 13 the shows the double amount b paid by the company for managing the their fixed payment details .

3. Prepare Amortizations schedules for AFC

DATE

PAYMENT

PRINCIPAL

INTEREST

TOTAL INTEREST

BALANCE

Mar. 2013

$2,633.38

$1,633.38

$1,000.00

$1,000.00

$98,366.62

Apr-13

$2,633.38

$1,649.72

$983.67

$1,983.67

$96,716.90

May-13

$2,633.38

$1,666.21

$967.17

$2,950.84

$95,050.68

Jun-13

$2,633.38

$1,682.88

$950.51

$3,901.34

$93,367.81

Jul-13

$2,633.38

$1,699.71

$933.68

$4,835.02

$91,668.10

Aug. 2013

$2,633.38

$1,716.70

$916.68

$5,751.70

$89,951.40

Sept. 2013

$2,633.38

$1,733.87

$899.51

$6,651.22

$88,217.53

Oct. 2013

$2,633.38

$1,751.21

$882.18

$7,533.39

$86,466.32

Nov. 2013

$2,633.38

$1,768.72

$864.66

$8,398.05

$84,697.60

Dec. 2013

$2,633.38

$1,786.41

$846.98

$9,245.03

$82,911.19

Jan. 2014

$2,633.38

$1,804.27

$829.11

$10,074.14

$81,106.92

Feb. 2014

$2,633.38

$1,822.31

$811.07

$10,885.21

$79,284.61

Mar. 2014

$2,633.38

$1,840.54

$792.85

$11,678.06

$77,444.07

Apr-14

$2,633.38

$1,858.94

$774.44

$12,452.50

$75,585.13

May-14

$2,633.38

$1,877.53

$755.85

$13,208.35

$73,707.60

Jun-14

$2,633.38

$1,896.31

$737.08

$13,945.42

$71,811.29

Jul-14

$2,633.38

$1,915.27

$718.11

$14,663.54

$69,896.02

Aug. 2014

$2,633.38

$1,934.42

$698.96

$15,362.50

$67,961.59

Sept. 2014

$2,633.38

$1,953.77

$679.62

$16,042.11

$66,007.83

Oct. 2014

$2,633.38

$1,973.31

$660.08

$16,702.19

$64,034.52

Nov. 2014

$2,633.38

$1,993.04

$640.35

$17,342.54

$62,041.48

Dec. 2014

$2,633.38

$2,012.97

$620.41

$17,962.95

$60,028.51

Jan. 2015

$2,633.38

$2,033.10

$600.29

$18,563.24

$57,995.42

Feb. 2015

$2,633.38

$2,053.43

$579.95

$19,143.19

$55,941.99

Mar. 2015

$2,633.38

$2,073.96

$559.42

$19,702.61

$53,868.02

Apr-15

$2,633.38

$2,094.70

$538.68

$20,241.29

$51,773.32

May-15

$2,633.38

$2,115.65

$517.73

$20,759.02

$49,657.67

Jun-15

$2,633.38

$2,136.81

$496.58

$21,255.60

$47,520.86

Jul-15

$2,633.38

$2,158.17

$475.21

$21,730.81

$45,362.69

Aug. 2015

$2,633.38

$2,179.76

$453.63

$22,184.44

$43,182.93

Sept. 2015

$2,633.38

$2,201.55

$431.83

$22,616.27

$40,981.38

Oct. 2015

$2,633.38

$2,223.57

$409.81

$23,026.08

$38,757.81

Nov. 2015

$2,633.38

$2,245.81

$387.58

$23,413.66

$36,512.00

Dec. 2015

$2,633.38

$2,268.26

$365.12

$23,778.78

$34,243.74

Jan. 2016

$2,633.38

$2,290.95

$342.44

$24,121.22

$31,952.79

Feb. 2016

$2,633.38

$2,313.86

$319.53

$24,440.74

$29,638.94

Mar. 2016

$2,633.38

$2,336.99

$296.39

$24,737.13

$27,301.94

Apr-16

$2,633.38

$2,360.36

$273.02

$25,010.15

$24,941.58

May-16

$2,633.38

$2,383.97

$249.42

$25,259.57

$22,557.61

Jun-16

$2,633.38

$2,407.81

$225.58

$25,485.14

$20,149.80

Jul-16

$2,633.38

$2,431.89

$201.50

$25,686.64

$17,717.92

Aug. 2016

$2,633.38

$2,456.20

$177.18

$25,863.82

$15,261.71

Sept. 2016

$2,633.38

$2,480.77

$152.62

$26,016.44

$12,780.95

Oct. 2016

$2,633.38

$2,505.57

$127.81

$26,144.25

$10,275.37

Nov. 2016

$2,633.38

$2,530.63

$102.75

$26,247.00

$7,744.74

Dec. 2016

$2,633.38

$2,555.94

$77.45

$26,324.45

$5,188.81

Jan. 2017

$2,633.38

$2,581.50

$51.89

$26,376.34

$2,607.31

Feb. 2017

$2,633.38

$2,607.31

$26.07

$26,402.41

$0.00

Accounting Entries for AFC lease constructing

Particulars

Debit

Credit

Fixed asset

100,000

Lease liability

92000

Cash

8000


accounting entries at the time of receipt of first’s rentals

For AFC

Particulars

Debit

Credit

Lease liability

$7,341.06

Interest

$2,760.00

Cash

10101.06


Related Solutions

You are a finance employee at a financial institution, specializing in originating auto loans in a...
You are a finance employee at a financial institution, specializing in originating auto loans in a country where auto loans have only been available for 2 years. Your group has just been informed that a close competitor has securitized $150 million in auto loans through an investment bank. Your boss wants to understand why the competitor did this. Explain. He also wants to understand the potential benefits for the following: The issuer The investors buying the ABS The individual borrowers...
Amerbrand Company was a diversified company that sold various consumer products, including food, tobacco, distilled, and personal care products and financial services.
Amerbrand Company (A)Amerbrand Company was a diversified company that sold various consumer products, including food, tobacco, distilled, and personal care products and financial services. Financial statements for the company for 2004 are shown in Exhibit 1. These statements reflect the following transactions (dollar amounts in thousands):1. Depreciation and amortization expense was $115,974.2. Net income included a loss of $66,046 resulting from the write-off of some obsolete equipment. The equip- ment had not yet been disposed of.3. Net income included $59,610...
Urban Drapers Inc., a draperies company, has been successfully doing business for the past 15 years....
Urban Drapers Inc., a draperies company, has been successfully doing business for the past 15 years. It went public eight years ago and has been paying out a constant dividend of $3.20 per share every year to its shareholders. In its most recent annual report, the company informed investors that it expects to maintain its constant dividend in the foreseeable future and that dividends are not expected to increase. If you are an investor who required a 30.00% rate of...
A finance company has a total of $30 million earmarked for homeowner and auto loans. On...
A finance company has a total of $30 million earmarked for homeowner and auto loans. On the average, homeowner loans have a 10% annual rate of return, whereas auto loans yield a 12% annual rate of return. Management has also stipulated that the total amount of homeowner loans should be greater than or equal to 4 times the total amount of automobile loans. Determine the total amount of loans of each type that Madison should extend to each category in...
Although the practice is doing well, business is down 20% from last year this time. The...
Although the practice is doing well, business is down 20% from last year this time. The practice has been losing some client and is not acquiring new clients as they were a year ago. During a meeting with your representatives, they noted that there are several factors in the market that they should consider carefully in relation to the practice’s marketing strategy.
1) What is finance? Define business finance. 2) Explain the types of finance. 3) Discuss the objectives of financial management
1) What is finance? Define business finance. 2) Explain the types of finance. 3) Discuss the objectives of financial management 4) Critically evaluate various approaches to the financial management. 
Yeshiva Financials (“YF”) is a small boutique firm that offers various financial services to qualified investors....
Yeshiva Financials (“YF”) is a small boutique firm that offers various financial services to qualified investors. On average, each customer generates $25,000 of sales per year for YF, which earns a margin of 25%. Its current retention rate is 75% per year, which is similar to other competitors in the market. Sales per customer are expected to be flat for the foreseeable future. Assume a 10% discount rate and an infinite consumption horizon. 1. The chief marketing officer is considering...
What is an Asset Management Company? What may be the products that it offers ?
Can someone please help me answer this homework question? The most thorough answer will get a guaranteed thumbs up!1. a) What is an Asset Management Company ?                  What may be the products that it offers ? Describe each.    b) In terms of Capital market / secondary market: what purpose does an            asset management company serve? Give an example of an existing            asset management company, with its structure.    c) Present some statistics and comparisons regarding the growth of Asset           management companies.
Prepare basic financial statements for various basic business structures.
Prepare basic financial statements for various basic business structures.
BUSINESS FINANCE Question 1 (20 marks) As companies grow in size, it is inevitable for the...
BUSINESS FINANCE Question 1 As companies grow in size, it is inevitable for the shareholders to hire management to run the operations of the business. The entire team of management, starting from the CEO and other top-level management, all the way to the middle and bottom level management are expected to perform towards the growth of the business. Since the shareholders of large companies are scattered across geographies, they appoint certain members as representatives who are elected to represent them...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT