Question

In: Finance

Illustration: Caterpillar Financial Services Corp. (a subsidiary of Caterpillar) and Sterling Construction Corp. sign a lease...

Illustration: Caterpillar Financial Services Corp. (a subsidiary of Caterpillar) and Sterling Construction Corp. sign a lease agreement dated January 1, Year 7, that calls for Caterpillar to lease a front-end loader to Sterling beginning January 1, Year 7. The terms and provisions of the lease agreement, and other pertinent data, are as follows.

•The term of the lease is five years. The lease agreement is noncancelable, requiring equal rental payments of $25,981.62 at the beginning of each year (annuity-due basis).

•The loader has a fair value at the inception of the lease of $100,000, an estimated economic life of five years, and no residual value.

•Sterling pays all of the executory costs directly to third parties except for the property taxes of $2,000 per year, which is included as part of its annual payments to Caterpillar.

•The lease contains no renewal options. The loader reverts to Caterpillar at the termination of the lease.

•Sterling’s incremental borrowing rate is 11 percent per year.

•Sterling depreciates, on a straight-line basis, similar equipment that it owns.

•Caterpillar sets the annual rental to earn a rate of return on its investment of 10 percent per year; Sterling knows this fact.

How do you find the minimum lease payment with financial calucator? btw the answer is 100,000

N=?

I/Y=?

PV=?

PMT=?

FV=?

Solutions

Expert Solution

Payment at beginning of each year = $ 25,981.62 ...(1)

property taxes (included in annual payments) per year = $ 2,000 ...(2)

minimum lease payment = (1) - (2) = 25,981.62 - 2,000 = 23,981.62 ...(3)

Above information also mentions residual value at 5th year = 0

Note: payments are made at beginning of each year, so beginning of year 1 would be t=0. So minimum lease payments would be:

at t=0: 23,981.62

at t=1: 23,981.62

at t=2: 23,981.62

at t=3: 23,981.62

at t=4: 23,981.62

PV(minimum lease payments) = 23,981.62 + PV(annuity, 4 years, payment of 23,981.62, 10% rate ) ...(4)

To calculate, PV(annuity, 4 years, payment of 23,981.62, 10% rate ) , in financial calculator,

N=4, PMT=23981.62, I/Y=10, FV=0 (as residual value is 0), PV=?

compute (CPT) PV, we get PV(annuity, 4 years, payment of 23,981.62, 10% rate ) = 76018.50859 ...(5)

Substituting value of equation (5) in equation (4), we get,

PV(minimum lease payments) = 23,981.62 + 76,018.50859 = 100,000.1286

{Note in above calculations my BA II Plus calculator was set in BGN mode value = END.}

You can also solve by setting your calculator to annuity-due mode with, BGN mode value = BGN.

To change modes - (2nd) (BGN) -> (2nd)(SET) -> (2nd)(QUIT)

If you set to BGN mode value = BGN,

N=5, PMT=23981.62, I/Y=10, FV=0 (as residual value is 0), PV=?

compute (CPT) PV, we get PV(minimum lease payments) = 100,000.1286.


Related Solutions

Caterpillar Financial Services Corp. (a subsidiary of Caterpillar) and Sterling Construction Corp. sign a lease agreement...
Caterpillar Financial Services Corp. (a subsidiary of Caterpillar) and Sterling Construction Corp. sign a lease agreement dated January 1, 2017, that calls for Caterpillar to lease a front-end loader to Sterling beginning January 1, 2017. The terms and provisions of the lease agreement, and other pertinent data, are as follows. • The term of the lease is five years. The lease agreement is non-cancelable, requiring equal rental payments at the beginning of each year (annuity-due basis). • The loader has...
2. Caterpillar Financial Services Corp. (a subsidiary of Caterpillar) and Sterling Construction Corp. sign a lease...
2. Caterpillar Financial Services Corp. (a subsidiary of Caterpillar) and Sterling Construction Corp. sign a lease agreement dated January 1, 2017, that calls for Caterpillar to lease a front-end loader to Sterling beginning January 1, 2017. The terms and provisions of the lease agreement, and other pertinent data, are as follows. • The term of the lease is five years. The lease agreement is non-cancelable, requiring equal rental payments at the beginning of each year (annuity-due basis). • The loader...
Caterpillar Financial Services Corp. (a subsidiary of Caterpillar) and Sterling Construction Corp. sign a lease agreement...
Caterpillar Financial Services Corp. (a subsidiary of Caterpillar) and Sterling Construction Corp. sign a lease agreement dated January 1, 2017, that calls for Caterpillar to lease a front-end loader to Sterling beginning January 1, 2017. The terms and provisions of the lease agreement, and other pertinent data, are as follows. • The term of the lease is five years. The lease agreement is non-cancelable, requiring equal rental payments at the beginning of each year (annuity-due basis). • The loader has...
Financial Statement Reporting for a Finance Lease Reynolds Construction (RC) needs a piece of equipment that...
Financial Statement Reporting for a Finance Lease Reynolds Construction (RC) needs a piece of equipment that costs $120,000. The equipment has an economic life of 3 years and no residual value. The equipment will not require maintenance because its useful life is so short. RC can borrow the full cost of the equipment at an interest rate of 6% with payments due at the end of the year. Alternatively, RC can lease the equipment for $45,000 with payments due at...
(Analysis of Percentage-of-Completion Financial Statements) In 2020, Steinrotter Construction Corp. began construction work under a 3-year...
(Analysis of Percentage-of-Completion Financial Statements) In 2020, Steinrotter Construction Corp. began construction work under a 3-year contract. The contract price was $1,000,000. Steinrotter uses the percentage-of-completion method for financial accounting purposes. The income to be recognized each year is based on the proportion of cost incurred to total estimated costs for completing the contract. The financial statement presentations relating to this contract at December 31, 2020, are shown below. Balance Sheet Accounts receivable $18,000 Construction in process $65,000 Less: Billings...
Silkworm Inc is a manufacturer of construction equipment, machinery and engines. It also sells financial services....
Silkworm Inc is a manufacturer of construction equipment, machinery and engines. It also sells financial services. You anticipate a substantial increase in its machinery sales. You have the following data. US $'000 2018 2019 Net sales 39,867 57,392 COGS 30,367 43,578 SG&A 4,248 5,203 and thus in percentage terms: % of sales 2018 2019 Net sales 100 100 COGS 76.2 75.9 SG&A 10.7 9.1 a) Estimate the fixed and variable components of COGS and SG&A in 2019. What would be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT