Question

Problem 3-04 (Part Level Submission) James Halabi is a financial executive with Cullumber Company. Although James has not had any formal training in finance or accounting, he has a "good sense" for numbers and has helped the company grow from a very small company ($390,000 sales) to a large operation ($35 million is sales). With the business growing steadily, however, the company needs to make a number of difficult financial decisions in which James Halabi feels a little "over his head." He therefore has decided to hire a new employee with "numbers" expertise to help him. As a basis for determining whom to employ, he has decided to ask each prospective employee to prepare answers to questions relating to situations he has encountered recently. The following are the facts for the first question asked of prospective employees. In 2019, Cullumber Enterprises negotiated and closed a lease contract for newly constructed truck terminals and freight storage facilities. On January 1, 2020, Cullumber took possession of the leased property. The 20-year lease is effective for the period January 1, 2020, through December 31, 2039. Advance rental payments of $620,000 are payable to the lessor (owner of facilities) on January 1 of each of the first 10 years of the lease term. Advance payments of $312,000 are due on January 1 for each of the last 10 years of the lease term. Cullumber has an option to purchase all the leased facilities for $1 on December 31, 2039. At the time the lease was negotiated, the fair value of the truck terminals and freight storage facilities was approximately $5.58 million. If the company had borrowed the money to purchase the facilities, it would have had to pay 10% interest. (a) Calculate the present value of the payments required of Cullumber Enterprises under the lease agreement. (For calculation purposes, use 5 decimal places as displayed in the factor table provided. Round answers to o decimal places, e.g. 5,275.) Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1. Steps to be followed include: 1. Calculate the present value of the future cash flows for the advance rental payments of $620,000 for the period from January 1, 2020, through December 31, 2029. Hint: If using factor tables, because the lease payments are due at the beginning of each year, use the PV.2 regular annuity table for nine years and add the first payment of January 1, 2020, in your calculation. 2. Calculate the present value of the future cash flows for the advance rental payments of $312,000 for the 10-year period beginning January 1, 2030. Hint: If using factor tables, as in the first step, use the PV.2 regular annuity table for 10 years for the present value at January 1, 2029. 3. Take the calculation result of step 2 and arrive at the present value of that amount at January 1, 2020, by using nine years in your discount calculation. 4. Add the result of the first and third steps to arrive at the total cost of leasing

Answer 1

NOTE - There may be rounding off differences in the answer. I have rounded off the factors to FIVE decimal places. In case you need any assistance please comment

1.

Date	Years to discount	Amount	PV Factor	Present Value
			1/ (1 + 10%)^Year
Jan 1, 2020	0	$ 620,000	1	$      620,000
Jan 1, 2021	1	$ 620,000	0.90909	$      563,636
Jan 1, 2022	2	$ 620,000	0.82645	$      512,399
Jan 1, 2023	3	$ 620,000	0.75131	$      465,812
Jan 1, 2024	4	$ 620,000	0.68301	$      423,466
Jan 1, 2025	5	$ 620,000	0.62092	$      384,970
Jan 1, 2026	6	$ 620,000	0.56447	$      349,971
Jan 1, 2027	7	$ 620,000	0.51316	$      318,159
Jan 1, 2028	8	$ 620,000	0.46651	$      289,236
Jan 1, 2029	9	$ 620,000	0.4241	$      262,942
				$   4,190,592

2.

Date	Years to discount	Amount	PV Factor	Present Value
			1/ (1 + 10%)^Year
Jan 1, 2030	1	$ 312,000	0.90909	$      283,636
Jan 1, 2031	2	$ 312,000	0.82645	$      257,852
Jan 1, 2032	3	$ 312,000	0.75131	$      234,409
Jan 1, 2033	4	$ 312,000	0.68301	$      213,099
Jan 1, 2034	5	$ 312,000	0.62092	$      193,727
Jan 1, 2035	6	$ 312,000	0.56447	$      176,115
Jan 1, 2036	7	$ 312,000	0.51316	$      160,106
Jan 1, 2037	8	$ 312,000	0.46651	$      145,551
Jan 1, 2038	9	$ 312,000	0.4241	$      132,319
Jan 1, 2039	10	$ 312,000	0.38554	$      120,288
				$   1,917,103

3.

PV at January 1, 2020 = 1,916,928 X 0.42410 = 813,043

4.

Total cost = 813,043 + 4,190,592 = 5,003,636