Managerial Decision Making Assignment | Homework For You

Can you send the excel file if I provide an email address?

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

This is a question on managerial decision making with excel spreadsheet. A step wise how to solve this will be appreciated for homework and not any exam. A model in excel will really help.Homework For You

John’s Truck

John owns John’s Truck Rental, which is currently for sale for $650,000. He would like you to develop a five-year spreadsheet model to assist buyers in their evaluation of the company.

The company currently has a fleet of 100 trucks, which are rented out for $15,000 per year. At this rental rate, the average utilization of the fleet is 62%. He believes that for every $1,500 decrease in the annual rental rate, the utilization will increase by 7%. Conversely, the same size increase in the rental rate will lead to a decrease of the same amount. The spreadsheet model should be able to handle a change in rental rate and calculate the corresponding change in utilization- the user should not be limited to increments of $1,500 only (assume that fractional values of utilization are acceptable as these are annual averages of utilization). The annual rental rate should be set once and held steady for all five years of the model.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

The cost of maintaining the fleet runs $4,800 per truck per year (regardless of utilization), which includes inspection fees, licenses, normal maintenance, and storage. These maintenance costs are expected to increase by 9% per year. The company has fixed office costs of $60,000 per year, which are expected to remain stable, and pays property taxes of $35,000, which is expected to grow at a rate of 3% per year. Profits are subject to a 30% income tax rate (and losses, if incurred, are not taxed).

At the end of five years, it is assumed that the buyer will resell the business for cash. John estimates the selling price at that time to be three times the gross revenue in that final year. Cash flow in the final year would include cash from the sale of the business, which would be taxed at the same rate as annual income (and we will assume full depreciation of the trucks has already occurred, thus no tax effects). Investment profit for the buyers is defined to be the Net Present Value of the annual cash flows (all operating revenues and expenses are in cash), computed at a discount rate of 10%. The calculation of NPV includes the purchase price, incurred at the beginning of Year 1, and net income from the operations (include the sale price in Year 5) over five years.

To do

  1. Build the spreadsheet model to solve this problem. Make sure you follow the guidelines for good spreadsheet design including proper cell referencing, good flow/layout, etc. Your grade on this portion of the HW reflects having correct calculations, following guidelines and creating a well-designed and easy-to-use worksheet.
    • Use Excel functions to help you, as necessary.
  1. John is thinking about raising the selling price. Use Goal Seek to find the point at which the NPV hits $1 million (John considers the point at which it might be hard to find a buyer).
    • What is the selling price at which this NPV occurs? Write the answer to this question somewhere (easy to find) on your worksheet.
    • Make sure to reset the selling price to the base value before proceeding to Task 3!Homework For You
  1. John would to have some additional analysis available on the spreadsheet to provide the potential buyers with information that might help inform their decision. He would like you to analyze the effect of the annual rental rate on the NPV. You recommend using a Data Table. Build this table on the same worksheet as your model, using values of annual rental rate ranging from $10,500 to $19,500 in increments of $1,500. Beyond including the corresponding NPV output values, you want to include the utilization rates in this table to confirm for the potential buyer that these changes are being calculated correctly.
    • Based on the results of the table alone, what is the annual rental rate that is most attractive to a potential buyer?

Homework Submission Instructions:

  • Upload your completed Excel workbook
  • Make sure that your model has the correct base-case input values and results!
  • Use at least 2 decimal places for any fractional value. Get Finance homework help today

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Education
Well done. I just needed to rephrase a few things, but overall good.
Customer 458067, January 29th, 2022
Military
Good job
Customer 456821, November 2nd, 2022
Nursing
Excellent work!!!
Customer 453939, June 16th, 2020
Other
Michelle is a great writer! Assignment on time.
Customer 463427, October 1st, 2022
Psychology
This well done
Customer 452763, November 26th, 2021
History
Excellent work.
Customer 463001, June 12th, 2022
Religious studies
Thank you very much. I am going to keep using this service.
Customer 454195, March 30th, 2020
Foundations of Language and Literacy for Diverse Prekindergarten and Kindergarten Learners
Always cite used resources.
Customer 454463, May 2nd, 2022
Social Work and Human Services
All of the papers I have so far received have me extremely satisfied. The content that is asked for each task is written by the writers in great detail, and they perform a fantastic job of it. I'll keep using the service and tell other people about it. Again, many thanks.
Customer 463411, January 29th, 2023
Human Resources Management (HRM)
Good work.
Customer 463125, July 4th, 2022
Interior Decoration
Excellent work! We look down to your future contribution
Customer 463463, November 16th, 2022
SAP (Sociology, Anthropology & Psychology)
Good work.
Customer 462275, June 21st, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat