Question

In: Finance

Geoffrey is the owner of a small grocery store, and is considering buying a car to...

Geoffrey is the owner of a small grocery store, and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $27,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: Insurance and registration will cost $580 per year, payable at the start of each year Based on mileage estimates, petrol will cost $260 per fortnight, payableat the end of each fortnight Servicing will cost $360 per year, payable at the end of each year (as the car was recently serviced by the previous owner Assume that these are the only expenses involved with the purchase and operation of the car. Geoffrey believes that the car can be used for 5 years before it will no longer be reliable, at which point he expects to sell it for a quarter of its current purchase price. He also has a business account at the bank that lets him borrow or invest money at 4.0% per annum effective. (a) Calculate the present value of the running costs (i.e. the insurance and registration, the petrol, and the servicing). (b) Calculate the present value of the sale price. (c) What is the total cost of buying and running the car in today's dollars? Your answer should also take into account the eventual sale price. (d) What is the equivalent monthly repayment over the next 5 years, where payments are made at the end of each month? Use Excel To Find Answer

Solutions

Expert Solution

(a ): Present value of running costs= $34,957.12

(b ): Sales price expected= Quarter of purchase price= $27,000*25% =$ 6,750

Present value of sale price= $5,548.01

(c ): Cost of buying and running the car= $56,409.11

(d): Equivalent monthly repayment over the next 5 years, where payments are made at the end of each month= $1,038.86

Calculations as below:


Related Solutions

Geoffrey is the owner of a small grocery store, and is considering buying a car to...
Geoffrey is the owner of a small grocery store, and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $33,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: Insurance and registration will cost $550 per year, payable at the start of each year Based on mileage estimates, petrol will cost $290...
Geoffrey is the owner of a small grocery store and is considering buying a car to...
Geoffrey is the owner of a small grocery store and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $40,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: • Insurance and registration will cost $510 per year, payable at the start of each year • Based on mileage estimates, petrol will...
Geoffrey is the owner of a small grocery store, and is considering buying a car to...
Geoffrey is the owner of a small grocery store, and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $37,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: Insurance and registration will cost $440 per year, payable at the start of each year Based on mileage estimates, petrol will cost $270...
Geoffrey is the owner of a small grocery store, and is considering buying a car to...
Geoffrey is the owner of a small grocery store, and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $32,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: Insurance and registration will cost $440 per year, payable at the start of each year Based on mileage estimates, petrol will cost $260...
Geoffrey is the owner of a small grocery store, and is considering buying a car to...
Geoffrey is the owner of a small grocery store, and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $26,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: Insurance and registration will cost $530 per year, payable at the start of each year Based on mileage estimates, petrol will cost $220...
Geoffrey is the owner of a small grocery store, and is considering buying a car to...
Geoffrey is the owner of a small grocery store, and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $39,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: Insurance and registration will cost $400 per year, payable at the start of each year Based on mileage estimates, petrol will cost $260...
ONLY ANSWER QUESTION IN BOLD Geoffrey is the owner of a small grocery store, and is...
ONLY ANSWER QUESTION IN BOLD Geoffrey is the owner of a small grocery store, and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $32,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: Insurance and registration will cost $440 per year, payable at the start of each year Based on mileage...
Development Strategies Lucas is a proud owner of a small grocery store wherein he keeps track...
Development Strategies Lucas is a proud owner of a small grocery store wherein he keeps track of his business transactions and records on his own personal computer. Using his knowledge, he was able to create a database to keep track of the inventory which is manually updated. Using his self-devised system, he was able to track expenses and do the payroll for his employees. The business itself has grown out of proportion and Lucas decided to install a software to...
You are a grocery store manager. The owner has a lot to say about how your run the store. The owner wants the grocery store to start selling rotisserie chickens.
You are a grocery store manager. The owner has a lot to say about how your run the store. The owner wants the grocery store to start selling rotisserie chickens. This is a new product. You know that you can buy chickens from a local farmer for $2/chicken and it would take you an additional $0.20/chicken to cook it. The grocery store currently pays $4,000/month in mortgage (unrelated to the chickens) and would spend $300 advertising the new rotisserie chickens....
Frederick opened a small organic grocery store last year and is considering the profits he made....
Frederick opened a small organic grocery store last year and is considering the profits he made. His store took in $120,000 in total revenue. To rent his storefront for the year, he had to invest $40,000. To supply it with the shelves, refrigerators, registers, and other miscellaneous equipment necessary, he had to invest another $10,000. Over the course of the year, he paid his employees a total of $35,000. To run his new business, he had to give up his...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT