1. Your organization has decided to purchase a building, a piece of office equipment, vehicle, or...

 

Transcribed Image Text:

1. Your organization has decided to purchase a building, a piece of office equipment, vehicle, or some other type of long-term asset. Select a long-term asset to purchase that your organization would likely need to operate. Once you have selected an asset, research the cost and make a decision to purchase. (Note - it could be from your list in part 2 of this project.) Calculate the monthly payment with a reasonable interest rate and length of time. Use the PMT formula in Excel to calculate the payment. You do not need to upload your Excel spreadsheet where you calculated the payment, but you do need to provide the following: Cost: Yearly interest rate:_ Number of years to pay off the loan:_ Monthly payment amount:_ 1. Your organization has decided to purchase a building, a piece of office equipment, vehicle, or some other type of long-term asset. Select a long-term asset to purchase that your organization would likely need to operate. Once you have selected an asset, research the cost and make a decision to purchase. (Note - it could be from your list in part 2 of this project.) Calculate the monthly payment with a reasonable interest rate and length of time. Use the PMT formula in Excel to calculate the payment. You do not need to upload your Excel spreadsheet where you calculated the payment, but you do need to provide the following: Cost: Yearly interest rate:_ Number of years to pay off the loan:_ Monthly payment amount:_

Answer rating: 100% (QA)

Cost 1000000 yearly i... View the full answer