Question

Holly wants to explore the difference between buying and leasing a vehicle, both over 5 years with monthly payments. The car that she has an interest in has a value of $27 000, and is located in Winkler, MB. If she purchases the vehicle, she can do so with 3% financing. If she leases the vehicle, there is a residual rate of 51%, an acquisition fee of $495 and an interest rate of 5% (no security deposit is required).

Find the monthly payments for the purchase and lease of the vehicle. Holly wishes to lease the vehicle and invest what she saves on every month's payment in a savings account with an interest rate of 6.4%, compounded monthly.

After the 5 years, she wishes to take the value of her investment and use it to buy out the residual value of the car. When she does that, how much is she left with/does she owe?

This assignment is worth 8 marks. Use the following information to guide your work:

2 marks for filling out the buy/lease spreadsheet properly
1 mark for correctly identifying the monthly payments
1 mark for correctly identifying the amount saved each month
2 marks for showing work using an appropriate tool to calculate the value of the investment
1 mark for finding the correct value of the investment
1 mark for finding the amount of money Holly will have left over or the amount she will still owe

Answer 1

Buy	Lease
27000	5 yrs
3% int	Int 5%
	Residue	51%
	Acq fee	495
Buy option		Lease option	Savings from purchase
Yearly payment	3% PVF	PVCF (A)	Monthly payment		Yearly payment	5% PVF	PVCF (B)	Monthly payment	Savings per year (A-B)
5,400	0.9709	5242.718447	436.89		5,400	0.95238	5142.86	428.57	100
5,400	0.9426	5090.017909	424.17		5,400	0.90703	4897.96	408.16	192
5,400	0.9151	4941.764961	411.81		5,400	0.86384	4664.72	388.73	277
5,400	0.8885	4797.830059	399.82		5,400	0.8227	4442.59	370.22	355
5,400	0.8626	4658.087436	388.17		5,400	0.78353	4231.04	352.59	427
									1,351
Savings per year	Savings per month	Interest per month @6.4%	Amount received after one month	Amt per year
100	8.3	6.39	14.71	176.55
192	16.0	12.29	28.30	339.56
277	23.1	17.73	40.82	489.81
355	29.6	22.74	52.34	628.06
427	35.6	27.33	62.92	755.02
				2,389.00											ekkarill92 Next > < Previous Related Solutions 5. Holly has received various gifts over the years. She has decided to dispose of the... 5. Holly has received various gifts over the years. She has decided to dispose of the following assets she received as gifts (assume for each of the gift transactions that no gift tax paid). Please answer the questions for each alternative scenario. a. In 1997, she received a land worth $98,000. The donor's adjusted basis was $ 110,000. Holly sells the land for $102,000 in 2017. Gift property basis: Holly’s gain/loss on the sale: b. In 2001, she received stock... What is the difference in future value if $40,000 is invested at 5% over twenty years,... What is the difference in future value if $40,000 is invested at 5% over twenty years, with one option compounding interest annually, while the other is based on monthly compounding? Reflect upon the differences between purchasing a $30,000 vehicle and leasing it. Provide one scenario in... Reflect upon the differences between purchasing a $30,000 vehicle and leasing it. Provide one scenario in which it would be advantageous for a company to purchase the vehicle and another scenario in which it would be advantageous to lease. * Please explain clearly your answer. Thank you! The Pepsi Corporation wants to explore the relationship between the daily temperature in California and the... The Pepsi Corporation wants to explore the relationship between the daily temperature in California and the quantity of soft drinks that it sells at Dadger’s Baseball Stadium. The average daily temperature for 12 randomly selected days and the quantity of soft drinks sold on each of these days are given below: Average Daily Temperature 70 75 80 90 93 98 72 75 75 80 90 95 Quantity Sold (thousands) 30 28 40 52 57 54 27 38 32 46 49... Refl   Reflect upon the differences between purchasing a $30, 000 vehicle and leasing it. Provide one scenario... Refl   Reflect upon the differences between purchasing a $30, 000 vehicle and leasing it. Provide one scenario in which it would be advantageous for a com company to purchase the vehicle, and another scenario in which it would be be advantageous to lease. The production department of Celltronics International wants to explore the relationship between the number of employees... The production department of Celltronics International wants to explore the relationship between the number of employees who assemble a subassembly and the number produced. As an experiment, 3 employees were assigned to assemble the subassemblies. They produced 12 during a one-hour period. Then 5 employees assembled them. They produced 20 during a one-hour period. The complete set of paired observations follows. Number of Assemblers One-Hour Production (units) 3 12 5 20 2 6 6 25 4 17 The dependent variable... The production department of Celltronics International wants to explore the relationship between the number of employees... The production department of Celltronics International wants to explore the relationship between the number of employees who assemble a subassembly and the number produced. As an experiment, 2 employees were assigned to assemble the subassemblies. They produced 13 during a one-hour period. Then 4 employees assembled them. They produced 22 during a one-hour period. The complete set of paired observations follows. Number of Assemblers One-Hour Production (units) 2 14 4 20 1 7 5 23 3 16 The dependent variable... The production department of Celltronics International wants to explore the relationship between the number of employees... The production department of Celltronics International wants to explore the relationship between the number of employees who assemble a subassembly and the number produced. As an experiment, two employees were assigned to assemble the subassemblies. They produced 15 during a one-hour period. Then four employees assembled them. They produced 25 during a one-hour period. The complete set of paired observations follows. Number of Assemblers One-Hour Production (units) 2 15 4 25 1 10 5 40 3 30 The dependent variable... The difference between the underwriters' buying price and the offering price of the securities to the... The difference between the underwriters' buying price and the offering price of the securities to the public is called the _. a Spread b Underpricing c Signalling d New issue premium What is the difference between the buying process and consumer decision making? What is the difference between the buying process and consumer decision making? ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions - A primary sedimentation basin for a municipal waste water treatment plant treats a flow of... Hello I'm currently having an error that says "main is not abstract and does not override... Give a direct proof of the following theorem, upon which case you can use it for... A7X Corp. just paid a dividend of $1.35 per share. The dividends are expected to grow... Please use Java language in an easy way with comments! Thanks! Create a calculator that uses... Due Thursday  (Normal late penalties apply for late submission.) Respond to the following in a minimum of... 1. You must evaluate a proposal to buy a new milling machine. The base price is... ADVERTISEMENT About @ 2020 WizEdu