Question

In: Finance

Read the assignment and answer the questions. You must also upload your Excel file, Word document...

Read the assignment and answer the questions. You must also upload your Excel file, Word document or pdf showing your work.

Bodacious Building Co. is considering four different acquisition methods for obtaining pickup trucks. If the contractor’s MARR is 6%, which alternative do you recommend? The alternatives are:

  1. Immediate cash purchase of the trucks for $22,500 each, and after five years sell each truck for an estimated $4,900.
  2. Lease the trucks for five years for $4,000 per year paid at the end of each year; the lease agreement includes a down payment of $3,900 due immediately. The contractor pays all operating and maintenance costs for the trucks, and the leasing company retains ownership.
  3. Purchase the trucks using an installment plan requiring an immediate down payment of $6,000 and $5,200 per year at the end of each year for four years. Assume the trucks will be sold after five years for $4,900 each.
  4. Lease the trucks for five years, paying $4,100 at the beginning of each year (6 payments).

Which alternative do you recommend?
What is your calculated NPV for alternative A?
What is your calculated NPV for alternative B?
What is your calculated NPV for alternative C?
What is your calculated NPV for alternative D?

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE


Related Solutions

Please upload your calculations (e.g., an Excel spreadsheet, a Word document, a PDF file, or a...
Please upload your calculations (e.g., an Excel spreadsheet, a Word document, a PDF file, or a picture of your work) for Q21. Q21. Consider a 2-year bond. The coupon rate of the bond is 10%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8.0% annually, or 4.0% semi-annually. (a) What is the duration of the bond measured in half-years and in years? (10 points) (b) If the semi-annually yield changes from 4.0%...
In order to submit this assignment, you will use this webform to upload a document file...
In order to submit this assignment, you will use this webform to upload a document file (.doc) or (.docx) with your answers. If you need to make a graph you may use a drawing program or sketch by hand. Report your source in APA or MLA format. Be sure that your responses model clear economic reasoning and addresses each of the following: What are the advantages and disadvantages of a fixed exchange rate? What are the advantages and disadvantages of...
In order to submit this assignment, you will use this webform to upload a document file...
In order to submit this assignment, you will use this webform to upload a document file (.doc) or (.docx) with your answers. If you need to make a graph you may use a drawing program or sketch by hand. Report your source in APA or MLA format. Be sure that your responses model clear economic reasoning and addresses each of the following: What is the effect of expansionary fiscal policy on unemployment and inflation? Go online and find an article...
In order to submit this assignment, you will use this webform to upload a document file...
In order to submit this assignment, you will use this webform to upload a document file (.doc) or (.docx) with your answers. You may use a drawing program or sketch by hand. Be sure that your responses model clear economic reasoning and addresses each of the following: 1.) Suppose if the price of a good is $12, the quantity demanded is 50 units; when the price is $10, the quantity demanded is 100 units. Use the midpoint approach to compute...
This assignment must be completed on a Word Document and submitted. All questions related to the...
This assignment must be completed on a Word Document and submitted. All questions related to the case study must be answered completely in order to receive full credit. This case study assesses SLO #2: "On completion of this course, student will describe steps taken to prevent and manage medical emergencies in the dental office." You have just seated your patient to have a tooth prepared for a crown. It has already been a hectic morning and the dentist has urged...
Answer the following problems in an Excel file. Please upload only one Excel file with all...
Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation rather than a calculation). All problems must be solved using the PV and FV functions in Excel. If I deposit $8,000 in a bank account that pays interest of 1.5%, compounded annually, how much will I have in the account after 10 years? If I deposit $8,000 in a bank account that pays simple interest...
For this assignment, you will read the scenario and then use the provided Excel and Word...
For this assignment, you will read the scenario and then use the provided Excel and Word document templates to complete your assignment before uploading them to the assignment submission area. Scenario Larry and Beth are both married, working adults. They both plan for retirement and consider the $6,000 annual contribution a must. First, consider Beth's savings. She began working at age 20 and began making an annual contribution to her IRA of $6,000 each year until age 32 (12 contributions)....
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. The Jackpots Dreams Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,600 units that averaged 65 percent complete. Ending work in process inventory was...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. Electric Car Co (ECC). currently manufactures two different types of fully electronic cars in 2021. Type 8Y is a large SUV whereas Type 8W will be the fastest car in the world with 10 rocket thrusters. ECC has decided to use ABC costing instead of traditional costing. The 2021 budget to manufacture these new types include manufacturing overhead...
. You must use Excel (submit either a pdf, word or Excel file only). . You...
. You must use Excel (submit either a pdf, word or Excel file only). . You must identify the 5 steps (you must address each in detail). Problem: Use the given data to complete a t-test using Excel. Question: Is there a difference in group means between the number of words spelled correctly for two groups of fourth graders? Group Assignment Score 1 3 1 4 1 10 2 14 2 7 2 8 2 10 2 15 2 9...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT