这个作业是用Excel计算贷款利息、盈利预测等问题
INFOMGMT 192 Assignment #2

Problem 1. Maintenance Checkup
RentFun is a business that uses booths to rent digital discs. The quality of the discs worsens
to the extent that RentFun considers them to be defective.
RentFun wants to maintain a stock of discs that are at least 90 percent acceptable. RentFun has
hired you to create a report that assesses each disc based on:
• Total number of times each title has been rented
• Number of times each title has reported defects
• The percent acceptable must be above 90% based on usage. If the percentage acceptable is
below 90%, RentFun wants to label the disc as “DISCARD.”
RentFun has given you with the data in a file called RentFun.xlsx. The figure below displays a
sample of the output that RentFun needs.
Problem 2. Loan Estimation
Katia wants to buy a more recent car to replace her current one. Katia’s bank offers her an annual
interest rate of 5.00% for a two-year loan. By selling her old car and using her savings, Katia has
$5,000 available as a down payment. Under her current budget, Katia figures out that the maximum
monthly loan payment she can pay is $500. She wants to find out the maximum car price she can
buy and keep the monthly payment no higher than $500. She cannot change the interest rate or
the two-year term.
Using Goal Seek, determine the highest purchase price Katia can afford.