Question: Mark and Beth are looking at four
Mark and Beth are looking at four different homes. They created this spreadsheet to estimate escrow calculations more easily. They will pay the property tax and homeowner’s insurance each month with their mortgage payment. The bank will hold these two amounts in escrow until those bills need to be paid, which is every 6 months. Each line represents data for a different home they are looking at. Mark and Beth input values for the mortgage, property tax, and homeowner’s insurance in rows 2–5, columns A, B, and C. 
a. Write the spreadsheet formula for cell D2 that will compute the escrow balance after 1 month. If the monthly escrow payments get 1% interest compounded monthly, Mark and Beth can compute the value of the escrow account in 6 months. Look at this as finding the future value of a periodic deposit. Recall the formula from Section 3-8 shown at the left. b. Write the spreadsheet formula for cell E2 that will compute the escrow balance after 6 months, with the given interest rate and monthly compounding. c. Fill in the missing entries. 
Transcribed Image Text:
A B C D E Annual Escrow Balance Monthly 1 Mortgage Property Tax Annual Homeowner's Monthly Escrow with Interest after Рayment Insurance Six Months 2 1,435 5,900 1,234 d. 3 1,987 8,766 1,567 е. f. 4 2,081 8,944 1,540 g. h. 1,873 7,711 1,564 i. j. Future Value of a Periodic Deposit (1+)"-) В where B= balance at the end of the 6 months P = periodic deposit amount, which is the monthly escrow r = annual interest rate expressed as a decimal n = number of times the interest is compounded annually t= length of the investment in years
> Ron estimates that it will cost $400,000 to send his daughter to a private college in 18 years. He currently has $90,000 to deposit in an account. What simple interest rate must his account have to reach a balance of $400,000 in 18 years? Round to the ne
> Determine the distance covered by a car traveling x km/h for each unit and time given. a. kilometers in 1 hour b. meters in 1 hour c. meters in 1 minute d. meters in 1 second
> A couple is opening a savings account for a newborn baby. They start with $3,450 received in baby gifts. If no deposits or withdrawals are made, what is the balance of the account if it earns simple interest at 5% for 18 years?
> Mickey uses a mirror and similar triangles to find the height of a light pole near her driveway. The diagram describes her method. She has her friend move the mirror until she can see the top of the pole as a reflection in the mirror. Due to the law of
> The following stem-and-leaf plot gives the number of juniors who took a driver education course at Guy Patterson High School over the last two decades. Construct a box-and-whisker plot based on the data. 4123556 511888 9 6000
> Assume $20,000 is deposited into a savings account. Bedford Bank offers an annual rate of 1% simple interest for 5 years. Slick Bank offers a rate of 5.1% simple interest for 1 year. Which earns more interest?
> What interest rate is needed for $9,500 to earn $900 in 19 months? Round to the nearest hundredth of a percent.
> There are many online student loan calculators that can assist you. Examine the input boxes for one such calculator (Cost of Interest Capitalization Calculator www.finaid.org). After clicking “calculate,” the following information is reported: Comment 1:
> Suppose that Britta decided to take out a private loan for $12,000 for which loan payments start as soon as the loan amount is deposited in her account and continue for 10 years. The interest rate is 6.1%. a. Determine her monthly payment. b. What is
> Kaylee has 100/300/50 liability insurance and $50,000 PIP insurance. She drives through a stop sign, hits a telephone pole, and ricochets into a minivan with eight people inside. Some are seriously hurt and sue her. Others have minor injuries. Three pass
> Suppose Britta only paid the interest during her 2 years in school and the 6-month grace period. What will she pay in interest over the term of her loan? Britta has been accepted into a 2-year medical assistant program at a career school. She has been aw
> If Britta decides to make no payments during the 2.5 years, the interest will be capitalized at the end of that period. What will the new principal be when she begins making loan payments? Britta has been accepted into a 2-year medical assistant program
> Determine the distance covered by a car traveling 55 km/h for each unit and time given. Round answers to the nearest unit. a. kilometers in 1 hour b. meters in 1 hour c. meters in 1 minute d. meters in 1 second
> Read the quote at the beginning of this section. Interpret the quote in terms of what you have learned about student loans.
> Assume $x is deposited into a savings account. Blank Bank offers an annual rate of r% for y years. Thank Bank offers a rate of ry% for 1 year. Which earns more interest?
> Interpret the quote in the context of what you learned about home maintenance in this section.
> Britta made her last monthly interest-only payment on May 5. Her next payment is due on June 5. What will be the amount of that interest-only payment? Britta has been accepted into a 2-year medical assistant program at a career school. She has been award
> Find the simple interest on a $2,350 principal deposited for 6 years at a rate of 2.77%.
> Beth and Mark would like to put some savings in the bank. They most likely will not need this money for 4 years, so Beth wants to put it in a 4-year CD. Mark wants to put the money in a savings account. What is the advantage of a CD? What is the disadvan
> John, Paul, and George are having a disagreement over interest rates. John says that 6 % 3 4 can be expressed as 6.75%. George thinks that 6 % 3 4 can be expressed as 0.0675. Paul remembers converting percents to equivalent decimals and thinks it can be
> Linda’s savings account balance has fallen below the $1,000 minimum balance required to receive interest. It is currently $871.43. The monthly fee charged by the bank for falling below the minimum is x dollars. Express algebraically how you compute the n
> Josh has a savings account at a bank that charges a $10 fee for every month his balance falls below $1,000. His account has a balance of $1,203.44 and he withdraws $300. What will his balance be in 6 months if he makes no deposits or withdrawals?
> A finite arithmetic sequence has 12 terms. The last term is 100 and the common difference is 3. What is the first term?
> Determine the distance covered by a car traveling 80 km/h for each unit and time given. Round answers to the nearest unit. a. kilometers in 1 hour b. meters in 1 hour c. meters in 1 minute d. meters in 1 second
> Arrange the following interest rates in ascending order: 3.4%, 3.039%, 3% 3 16, 3.499%, 3%
> The sixth-grade class at West Side School starts a charity collection on Monday, with $78 donated by the Parents Organization. They plan to add $2 to the fund each day. How much will they have after 90 days?
> How long does it take $450 to double at a simple interest rate of 100%?
> Francoise’s car gets about 11 kilometers per liter. She is planning a 1,200-kilometer trip. a. About how many liters of gas should Francoise plan to buy? Round your answer to the nearest liter. b. At an average price of $0.89 per liter, how much should
> How long does it take $450 to double at a simple interest rate of 14%?
> How much simple interest does $2,560 earn in 17 months at a rate of 1 1/8%? Round to the nearest cent.
> Use the simple interest formula to find the missing entries in the table. Round monetary amounts to the nearest cent. Rate (to the nearest hundredth of a percent) Interest Principal $2,000 Time 3.35% 4 years a. b. $3,500 4.1% 15 months $20,100 5.5%
> Ryan deposits $775 in an account that pays 1.24% simple interest for 4 years. Brian deposits $775 in an account that pays 1.24% simple interest for 1 year. a. What is Ryan’s interest after the 4 years? b. What is Ryan’s balance after 4 years? c. How m
> How might those words apply to what has been outlined in this section? What “play on words” do you notice in Greenspan’s quote?
> An orchestra of 25 members bought tickets, at all different prices, to a concert, and the mean price paid was $82. A new musician joined the orchestra and spent $90 on his ticket to the same concert. What is the new mean price paid when the new musician
> There are 5,280 feet in a mile. Round answers to the nearest unit. a. How many miles does a car traveling at 42 mi/h go in 1 hour? b. How many feet does a car traveling at 42 mi/h go in 1 hour? c. How many feet does a car traveling at 42 mi/h go in
> Based on what you learned about dividends, why are non-dividend stocks compared to baseball cards?
> Jocelyn compiled data on the number of hours’ students work per week the summer after senior year. The minimum number of hours in the distribution was 23. The range was 17. a. What is the maximum number of hours in the distribution? b. If the maximum s
> A distribution of newly manufactured amusement park bumper cars has mean 400 pounds and standard deviation 2 pounds. A distribution of customers on line for the bumper-car ride has mean 60 pounds and standard deviation 2 pounds. Which distribution is mor
> Taking a cruise is a costly discretionary expense. In a recent year, the top five cruise lines in the world had this many passengers: 4,133,000 2,369,000 1,295,000 928,000 679,000 Round your answers to the nearest integer. a. The computations will be
> The Vetrone family members are all Cincinnati Reds baseball fans. They went to five games last season. The cost of each game, including parking, tickets, and food, is listed below. $266, $201, $197, $188, $162 Round your answers to the nearest cent. a
> Lenny’s car gets approximately 20 miles per gallon. He is planning a 750-mile trip. a. About how many gallons of gas should Lenny plan to buy? b. At an average price of $2.20 per gallon, how much should Lenny expect to spend for gas?
> An electric bill is an essential expense for young people who get their first apartment. The following is a list of Jordan’s monthly electric bills for the past 10 months. $115, $150, $144, $126, $90, $90, $95, $110, $120, $88 Round your answers to the
> A local comic book convention had an admission price of $17. During the week-long show, 19,344 people paid to enter. a. What is the range of the distribution of admission fees? b. What is the standard deviation of the distribution of admission fees? c
> Aileen is a salesperson at Lopez Sporting Goods. She is paid a monthly commission on all Little League uniforms she sells. She receives 10% of her first $2,000 in sales and 12% of the balance of her sales. Last week she earned $231.20. What was the total
> A car dealer pays d dollars for a car, which is sold for c dollars. The commission paid to the salesperson is 24% of the profit. Express the commission algebraically.
> McCormack Chrysler pays their sales staff by commission. They are paid a percent of the profit the dealership makes on the car. If the profit is $500 or less, the commission rate is 17%. If the profit is greater than $500 and less than or equal to $1,100
> There are 5,280 feet in a mile. Round answers to the nearest unit. a. How many miles does a car traveling at 65 mi/h go in 1 hour? b. How many feet does a car traveling at 65 mi/h go in 1 hour? c. How many feet does a car traveling at 65 mi/h go in 1
> Salespersons at the Kings Park Auto Giant are paid a commission, c(p), based on the profit, p. The following piecewise function gives the commission rules. a. If the profit is $1,500, what is the percent commission rate? b. If the profit is $900, what
> Appel’s Music Store pays its sales staff a commission of 9.5% of the first $1,000 in sales and 15.5% of the balance of sales. Alex, the store’s drum expert, received $1,234.25 in commission last week. What were his total sales for the week?
> Using the table from Example 2, find the assessed value of the house in the classified ad on the left. New Listing: Cape-Cod style home w/ 2 baths, 700 sq. ft first flr., upstairs 15 x 26 dormer, 12 x 20 garage, gas heat, frpl, basement. Property 1/
> The Merrick Oaks School District offers their employees the following annual pension benefit. First 15 Years of Service ……………………………………………. Service in Excess of 15 Years 2.12% multiplier ………………………………………………………………………… 2.25% multiplier Years of service up t
> Michael used his car for business last weekend. When he reports the exact number of miles he traveled, the company will pay him 52 cents for each mile. At the beginning of the weekend, the odometer in Michael’s car read 74,902.6 miles. At the end of the
> The Merrick Oaks School District offers their employees the following annual pension benefit. First 15 Years of Service ……………………………………………. Service in Excess of 15 Years 2.12% multiplier ………………………………………………………………………… 2.25% multiplier Years of service up t
> The Merrick Oaks School District offers their employees the following annual pension benefit. First 15 Years of Service ……………………………………………. Service in Excess of 15 Years 2.12% multiplier ………………………………………………………………………… 2.25% multiplier Years of service up t
> A commuter budgets $480 per month for transportation. She has determined that the cost of a round-trip train ride is $4 and the cost of each round-trip car ride (factoring in gas, oil, etc.) is $3. a. Write a budget line equation for this situation. b.
> Under his household expense budget category, Mark has allocated $60 per month for pet food. He can purchase wet food in a can for $1.50 per can or dry food in a bag for $3 per bag. a. Determine a budget line equation for this situation. b. Graph the bu
> A spreadsheet user inputs a speed in miles per hour into cell A1. a. Write a formula that would enter the approximate equivalent of that speed in km/h in cell A2. b. Write a spreadsheet formula that would enter the approximate total stopping distance i
> Rich budgets $2,500 in expenses for the month of January. He constructed the two graphs below. Using the prior year’s data and the budget he has created, he budgeted the transportation category for the year as follows. Each of the m
> Mark has two jobs. At his primary job he gets paid with commissions only. Therefore, his monthly income from this job varies. His secondary job has a fixed monthly income. His quarterly dividend checks and interest income have varied but not by a large a
> Aida created the following double bar graph. It illustrates the actual amount spent this year for household expenses per month and the budgeted amounts for the following year. Aida calculated the Year 2 budget amounts by adding a fixed percent increase t
> Construct a bar graph for the September budget category “Personal Items” using the following amounts: Haircut: $20, Clothing purchases: $60, Books: $20, Newspapers/magazines: $65, Online subscriptions: $30, Gifts: $80, Donations: $40, Other: $50.
> Construct a bar graph for Jason’s transportation budget expenses. 400 550 400 650 400 350 200 300 450 500 650 500 Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec
> Examine the following bar graph that shows budgeted monthly utility expenses for a 1-year period. a. In which months was the same amount budgeted? b. What is the total annual amount budgeted for utilities? c. What percent of the total yearly amount w
> Robbie’s car gets M miles per gallon. Write an algebraic expression that represents the number of gallons he would use when traveling 270 miles.
> Construct a pie chart that shows the following transportation-related expenses: Fuel: $240; Insurance: $80; Public transportation: $200; Parking garage: $120; Repairs: $160.
> Rachel’s health-related budget is as follows: The percentage budgeted for health insurance is four times the percentage for health club dues. The percentage budgeted for prescriptions is equal to one-fourth the percentage budgeted for health insurance. T
> Use the pie chart of a person’s monthly income. a. Suppose the total monthly income is $5,800. Determine the amounts in each income category. b. Suppose the income from the secondary job was $1,225. What would be the total monthly in
> Use the pie chart of a monthly entertainment budget. a. Suppose $600 was budgeted. Determine the exact amount for each category. b. Suppose $72 was budgeted for day trips. What would be the total amount budgeted for entertainment? c. Suppose $310 wa
> Create a year-long budget to chart these expenses: Savings: $600 bimonthly (starting in January); Retirement account: $2,000 quarterly; Checking account: $1,000 semi-monthly; Credit card: $500 monthly; Life insurance: $400 semi-annually; Real estate taxe
> Create a year-long budget check-off chart to chart the following transportation related expenses: Fuel: monthly; Insurance: quarterly; Car maintenance: every 3 months; Car wash: bimonthly; Parking: semi-annually; Public transportation: monthly.
> Explain how that quote can be interpreted in light of what you have learned in this lesson.
> Laura deposits $2,000 in an account that has an annual interest rate of 1.96%, compounded monthly. How much interest will she earn at the end of 1 month? Round to the nearest cent.
> Janine opens a savings account with a deposit of $720. The account pays 1.4% interest, compounded daily. What is the first day’s interest? Round to the nearest cent.
> If a family from the data set in question 2 had a z-score of 1.5, what was their daily expense for food and lodging?
> Becky is planning a 2,100-mile trip to St. Louis to visit a college. Her car averages 30 miles per gallon. About how many gallons will her car use on the trip?
> Interpret the quote in terms of what you have learned about essential and discretionary vacation expenses.
> Pierre deposits $9,000 in a certificate of deposit that pays 1.4% interest, compounded semi-annually. How much interest does the account earn in the first 6 months? What is the balance after 6 months?
> A company produces a security device known as Toejack. Toejack is a computer chip that parents insert between the toes of a child, so parents can track the child’s location at any time using an online system. The company has entered into an agreement wit
> Sally deposits $4,000 in a certificate of deposit that pays 2.12% simple interest. What is her balance after 1 year?
> Jerome deposits $3,700 in a certificate of deposit that pays 1.8% interest, compounded annually. How much interest does Jerome earn in 1 year?
> Getaway Sports is a vacation destination for the serious sports fanatic. Rajesh is in charge of equipment for the complex. The last shipment of Ping-Pong balls was normally distributed with a mean weight of 2.7 grams and a standard deviation of 0.1 gram.
> How might the words in the quote apply to what you learned about interest and savings in this section?
> One day before the end of the month, George had an opening balance of m dollars in an account that pays 1.25% interest compounded monthly. On the last day of the month, he made a deposit equal to twice his opening balance. Express his ending balance on t
> Using the data from question 2, you can compute the mean food and lodging cost of a 10-day vacation by multiplying the per-day mean by 10. The standard deviation for the 10-day vacation can be found by multiplying by 10 also. a. What is the mean for foo
> Linda has d dollars in an account that pays 1.4% interest, compounded weekly. She withdraws w dollars. Express her first week’s interest algebraically.
> On May 29, Rocky had an opening balance of x dollars in an account that pays 1.3% interest, compounded daily. He deposits y dollars. Express his ending balance on May 30 algebraically.
> Steve’s SUV has a 17-gallon gas tank. The SUV gets an estimated 24 miles per gallon. Approximately how far can the SUV run on half a tank of gas?
> A company produces a security device known as Toejack. Toejack is a computer chip that parents insert between the toes of a child, so parents can track the child’s location at any time using an online system. The company has entered into an agreement wit
> Dave wants to borrow $22,000 from First Finance Bank. The bank will give him a 15-year loan at an interest rate of 4.85%. How much will he pay the bank in interest over the life of the loan? Round to the nearest hundred dollars.
> Use your answer and the loan information from Exercise 8 to determine what effect a $50 decrease in Louis’s monthly payment would have on the length of his loan. Exercise 8: Louis wants to take out a $14,000 loan with a 6.8% APR. He can afford to pay n
> Louis wants to take out a $14,000 loan with a 6.8% APR. He can afford to pay no more than $400 per month for loan payments. What would be the length of his loan? Round to the nearest tenth of a year.
> Jennifer wants to borrow $20,000. Her bank offers a 7.1% interest rate. She can afford $500 a month for loan payments. What should be the length of her loan to the nearest tenth of a year?
> A bank offers a $25,000 loan at an interest rate of 7.7% that can be paid back over 2–10 years. a. Write the monthly payment formula for this loan situation. Let t represent the number of years from 2 to 10 inclusive. b. Write the total interest formul
> Kevin has x dollars in an account that pays 2.2% interest, compounded quarterly. Express his balance after one quarter in an algebraic formula.
> Charlie and Kathy want to borrow $20,000 to make some home improvements. Their bank will lend them the money for 10 years at an interest rate of 5.75%. How much will they pay in interest?
> Jamie wants to borrow $15,000 from South Western Bank. They offered her a 4-year loan with an APR of 5.5%. How much will she pay in interest over the life of the loan?
> What is the total interest on a 10-year, 6.1% loan with a principal of $32,000?
> Yolanda is planning a 778-mile trip to visit her daughter in Maryland. She plans to average 50 miles per hour. At that speed, approximately how long will the trip take? Express your answer to the nearest tenth of an hour. Then express your answer to the
> A company produces a security device known as Toejack. Toejack is a computer chip that parents insert between the toes of a child, so parents can track the child’s location at any time using an online system. The company has entered into an agreement wit
> In each case, the blue graph represents the expense function and the black graph represents the revenue function. Describe the profit situation in terms of the expense and revenue functions. dollars $100,000 price 100
