Buying A Car

ss.3

use excel to solve please

Which car to buy? Mr. Fox is a taxi company owner. He is going to buy a new car. Cars M, C, R suite his needs and the prices are 25000, 22000, 23000 euros accordingly. His decision will be based on total costs per kilometer criterion. All the necessary data is given in the table below. Table Costs of the cars Costs Car Fixed costs per year M R Salary 13200 13200 13200 Depreciation, 15% Car insurance, 8% *** Variable costs per 100 km Fuel 11.50 13.10 12.60 Oil 1.17 1.31 1.26 Maintenance and Repair 7.90 8.80 7.79 Tire wear 1.85 2.10 2.25 Calculate fixed, variable and total costs per kilometer for each car. Find a recommended price per kilometer, if 80% of it equals to the total costs per kilometer. Use the Data/Table tool to calculate an average criterion value and deviation from the average for each vehicle when the distance travelled per year changes from 10000 up to 40000 km in steps of 2000 km. build a chart of deviations to facilitate Mr. Fox decision. Write down your…

Set up and solve an equation for the following business situation. You are moving to a new home and have rented a truck to assist you with the move. Trailside Truck Rentals charges $39.95 per day plus 65 cents per mile. You will need the truck for 5 days and will travel 460 miles. What will be your total cost (in dollars) for the truck rental? $ If you have budgeted $450 for the truck rental, will this amount be sufficient to cover the cost? O yes no

Solve these general accounting question

1.1 Consider the following costs of owning and operating a car. An $18,000 Fiat 500 Pop financed over 60 months at 4 percent interest means a monthly payment of $331.50. Insurance costs $120 a month regardless of how much you drive. The car gets 35 miles per gallon and uses regular-grade gasoline that costs $2.60 per gallon. Finally, suppose that wear and tear on the car costs about 20 cents a mile. Which costs are fixed, and which are variable? What is the marginal cost of a mile driven? In deciding whether to drive from Atlanta to Las Vegas (about 2,000 miles round-trip), which costs would you consider? Why?

You have just been offered a contract worth $ 1.15 million per year for 7 years. However, to take the contract, you will need to purchase some new equipment. Your discount rate for this project is 12.4%. You are still negotiating the purchase price of the equipment. What is the most you can pay for the equipment and still have a positive NPV? Question content area bottom Part 1 The most you can pay for the equipment and achieve the 12.4% annual return is $ enter your response here million. Round to two decimal places.)

I could really use some help with this practice problem

What is the highest price they can pay on the new vehicle if they can afford a down payment of $4,000?Assume they finance their purchase for 48 months at 7.5%?

Suppose that you have an old car that is a real gas guzzler. It is 10 years old and could be sold to a local dealer for $400 cash. The annual maintenance costs will average $800 per year into the foreseeable future, and the car averages only 10 miles per gallon. Gasoline costs $3.50 per gallon, and you drive 15,000 miles per year. You now have an opportunity to replace the old car with a better one that costs $8,000. If you buy it, you will pay cash. Because of a two-year warranty, the maintenance costs are expected to be negligible. This car averages 30 miles per gallon. Should you keep the old car or replace it? Utilize a two-year comparison period and assume that the new car can be sold for $5,000 at the end of year two. Ignore the effect of income taxes and let your MARR be 15%. State any other assumptions you make.

Please try to solve it in 30 minute

You are considering the purchase of new living room furniture that costs $1,140. The store will allow you to make weekly payments of $25.12 for one year to pay off the loan. What is the EAR of this arrangment? Multiple Choice 27.39% 29.41% 32.99% 31.42%

From: Javier Subject: Battery Order The facilities group wants to install a battery-powered warehouse monitoring system. A normal set of batteries costs $150, runs three hours before recharging and can be recharged 500 times. The long- life batteries cost twice as much, run five hours before recharging, and can be recharged 500 times. Which set of batteries should they buy? The normal battery The long-life battery They are both the same I need more information

klp.3

Need question 3 please

3) New Project Investment| Wally loves your analysis. He has now asked you to evaluate potential new project investments. Both projects aim to make widgets. Widgets sell for $10 each. Project A will produce 4,500 units in the first year, 6,500 units in the second and third years and a whopping 44,000 units in the fourth year. Project A requires an investment of 7 machines each costing $50,000. Project B will produce 2,400 units in the first year, 2,200 units in the second year, 1,950 units in the third year and 1,460 units in the fourth year. Project B requires an initial investment of 1 machine worth $50,000. Wally has said that to make the analysis easier - you need not calculate depreciation on the machine, the tax shelter benefit or the residual value of the machine at the end of production. Wally just said I want you understand the cash flows from the information provided above. (a) Calculate the net present value for each of Project A and Project B, assuming a 15% cost of…

ou are preparing to produce some goods for sale. You will sell them in one year and you will incur costs of $ 76,000 immediately. If your cost of capital is 7%.  What is the minimum dollar amount you need to sell the goods for in order for this to be a​ non-negative NPV?       Question content area bottom Part 1 The minimum dollar amount is ​$XXX enter your response here .

all parts of the question please