simple questions needed be solved excel

/in /by

Nursingpapertutors.com stands out as a reputable writing company that delivers high-quality papers specifically designed for nursing students. With its specialization in the nursing field, commitment to quality, customization, and originality, timely delivery, dedicated customer support, and emphasis on confidentiality, Nursingpapertutors.com provides invaluable academic support to nursing students. As a reliable partner in their educational journey, Nursingpapertutors.com helps nursing students excel academically and prepares them to become competent and knowledgeable healthcare professionals.

Assignment:

 

Complete the following numbered problems using an Excel spreadsheet. You must show your work to get full credit.

 

  1. B&J Manufacturing is planning on purchasing a new assembly machine for $40,000 to automate one of its current manufacturing operations. It will cost an additional $3,000 to have the new machine installed. With the new machine, B&J expects to save $15,000 in annual operating and maintenance costs. The machine will last 5 years with an expected salvage value of $6,000. How long will it take to recover the investment (plus installation cost)?

 

  1. Consider the following investment projects, all with a five-year investment life:

 

n                      A                     B                     C                     D

 

0                      $-1000             $-2000             -$1000             $-6500

1                      $0                    $800                -$1500             $3000

2                      $0                    $1100              $1000              $2000

3                      $4000              $2000              $3500              $3000

 

            Compute the net present worth of each project at i=8%.

 

  1.  Consider the following set of investment projects, each with a four-year investment life:

 

n                      A                     B                     C                     D

 

0                      $-5000             $-2000             $5000              $-4500

1                      $6000              $-4500             -$700               $1250

2                      $2500              $6000              $3000              $5250

3                      $8500              $4000              $4500              $6500

 

Compute the net future worth of each project at i=15%.

 

  1. Consider the following cash flow data for two competing investment projects:

 

n                      A                                 B                                            

 

0                      $-1,250,000                 $-1,750,000                            

1                      $825,000                     $825,000                                

2                      $825,000                     $1,250,000                 

 

At i=10%, which of the two projects would be a better choice?

 

 

Nursingpapertutors.com places a premium on meeting deadlines. The company understands the significance of timely paper submissions for nursing students. To uphold their commitment to punctuality, Nursingpapertutors.com employs a well-organized workflow and efficient team coordination. This ensures that students receive their papers promptly, affording them ample time for review and making any necessary adjustments. Providing exceptional customer support is central to Nursingpapertutors.com’s mission. The company recognizes that nursing students may have queries or require assistance at any time of the day. As such, Nursingpapertutors.com offers 24/7 customer support to promptly address any concerns, clarify instructions, and offer updates on the paper’s progress. Their responsive support team ensures a seamless and positive experience for every student.

 

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.