18. In the month of October, candy production increases by a 7% every day until the 51 September, the total candy produced is 1.2 million per day. How much candy is made company meet a quota of 10 million by the end of the month? s by a 7% every day until the 31" of the month. At the end of r day. How much candy is made on October 31"? Can a 19. Every 5 years the price of a new car poes up by 8%. In 1975 a new car cost $12.500. How much soon expect to pay in the year 2020 for a new car? 20. Let's say you invest your money in a bank that offers annual compound interest at 5% for 10 years. If you put $30,000 into the account, how much should you expect out of it? (What is the balance?) that offered only 0.25% interest, how much is in the account 21 If vou invested $1200 of your money into a bank that offered only 0.25% interest how after you left it in the bank for 20 years compounded weekly? 22. Fill in the chart below using the information for Credit Card Finance. He starts with $1200 and an APR of 20.999 and makes no new purchases. The minimum payment is 7% and only the minimum is paid each month. New Balance Minimum Payment Finance Charge Month Beginning Balance $1200.00 23. What is the difference between the PMT and PV function in excel? Which one tells you the entire mortgage payment and which one only tells you the monthly payment? 24. Write down the exa down the exact formula you would type in excel to find the amount of payment from the information Yearly rate of 4%, 30 year mortgage, total mortgage is valued at $90,000 25. Write down the exact formula you would type in excel to calculate the total mortgage from the information. Yearly rate of 2.3%, 45 year mortgage, payments of $389 per month 26. Given the following photo, what amount is Cindy depositing each month? What yearly rate does she haver Clipboard Font SUM - : X fx fv1.0045/12,25*12,-260) 1 f.0045/12,35*12,-260) 27. For a college education, you plan to save up by starting early. What amount is expected at the end of 20 years if the rate is 4% yearly and you invest only $50 each month? Write the formula. Then use Excel to calculate the answer. 28. What amount do you pay each month for a loan of $8000 at a rate of 2% across 6 years? Write the formula Then use Excel to calculate the answer. 29. How much savings would you have if you contributed $50 with an employer match of 50% over 30 years? This savings account accumulates with a rate of 6.4%. Write the formula. Then use Excel to calculate the answer. 30. What amount should you pay each month to complete a $5000 loan that you have with 1.9% APR interest over length of 8 years? Write the formula. 31. If the bank can offer a rate of 5.85%, what exact formula would you type in excel to find the total amount in the retirement after 35 years if you contribute $100 a month? 32. How much more is in the retirement than what you actually invested? (Using excel, the amount in her account is $137,642.16.) Name. 6. A student has a test grade of 85%. If the student does extra problems and his grade raises by 15% of the tes what would be the new average score? Is he receiving a perfect score now? 7. A sample graph of profit was made by a company from year 0 to year 10. Answer the following questions ab the profit graph based on the data and trendline. y = 0.6782x + 4.26 Profit 7 8 9 10 11 0 1 2 3 4 5 6 Years after start What does the slope mean? (Interpret the number and write a sentence about it.) What is expected for year 5 after the start using the trendline? Is this above or below the actual data point? Write down the general formula for a linear model. Which is the dependent variable/independent variable