Merchandise Information and Loan Calculation
I created this project in order to display merchandise information and calculate merchandise loans and interest. This spreadsheet details merchandise (in this case, bicycles) owned by a retailer, and the cost and quantity of each item, total cost of all merchandise. Then using the total cost of all merchandise, the spreadsheet shows three possible loans with differing durations and interest, displaying the monthly payment of each loan as well as the interest accrued and paid. This project was completed using Microsoft Excel. One issue I faced when creating this project was working out the Excel commands while generating the loan information.
