2.99 See Answer

Question: You are constructing a future value spreadsheet.


You are constructing a future value spreadsheet. Users will be asked to enter the periodic investment in cell A3, the interest rate as an equivalent decimal in cell A4, the time in years in cell A5, and the number of times per year the interest is compounded in cell A6. Cell A8 will contain the future value of the periodic investment. Write the formula that will display this value in A8.



> Sascha was born in 1951. Her Social Security full retirement benefit is x dollars. She started collecting Social Security at age 65, so her benefit is reduced. Express her approximate Social Security benefit algebraically.

> Interpret the quote in the context of what you know about American history and/or the challenges facing senior citizens.

> As part of a study on exercising, Liam has to use a treadmill for 20 minutes each day, and then take and record his heart rate and blood pressure. Liam skips days, sometimes doesn’t do the entire 20 minutes, and sometimes forgets to record his heart rate

> A school’s student government organization is doing a study of students who copy each other’s homework. They randomly select 200 students and have them fill out an anonymous questionnaire. Which do you think is a greater problem in this scenario, nonresp

> Imagine a population of six brands of sneakers; All Star, Bikees, Cadverse, Didas, Evia, Falance. Represent these brands by the letters A, B, C, D, E, and F. a. How many different samples of size 2 can be taken without replacement? b. Make a list of al

> The New York Metropolitan area has nine major professional sports teams: Mets (M), Yankees (Y), Knicks (K), Rangers (R), Devils (D), Nets (N), Islanders (I), Giants (G), Jets (J) Marra’s Sporting Goods is going to randomly pick three teams to feature in

> Jack wants to buy a pair of name-brand headphones on a popular auction website. He enters the brand, make, and model number and searches the site for what is available. He notices that some headphones are being offered as “buy now&acirc

> Barnes and Noble had a $0.15 annual dividend during 2016. If you owned 500 shares of Barnes and Noble at that time, how much did you receive on a quarterly dividend check?

> The social studies department at Fox Ridge High School is looking to determine the current events knowledge of their juniors. Mrs. Gonzalez has a class of juniors in her social studies class and agrees to give the survey there. Explain why this survey is

> These six automobile designers need to test the ride comfort of a new prototype car: Amit (A), Bob (B), Chase (C), Dom (D), Eddie (E), Ferris (F) a. Only four at a time can ride in the car. How many different samples of four, taken without replacement,

> A local judicial system is seeking information on people to serve jury duty. They send a survey to all licensed drivers in their locale. Explain why this surveying technique is poor due to under coverage.

> Write a formula to determine the net change for each. Use the left side of the equation to indicate in which cell to store the formula. a. Microsoft Corp b. Apple Inc. A B C D E G H 1 February 25 Close February 24 Volume in Close Volume in Symbol

> When Derrick turned age 15, his grandparents put $10,000 into an account that yielded 1.4% interest, compounded quarterly. When Derrick turns 18, his grandparents will give him the money to use toward his college education. How much does Derrick receive

> Write the profit function for the given expense and revenue functions. E = 212,500p + 178,000 R = 21,450p2 + 155,000p

> Write a formula to determine the percent change for each of the following. Use the left side of the equation to indicate in which cell to store the formula. a. Apple Inc. b. Cooper Tire & Rubber Co A B C D E G H 1 February 25 Close February 2

> Write a formula to determine the close on February 24 for each of the following. Use the left side of the equation to indicate in which cell to store the formula. a. NETGEAR Inc. b. Ford Motor Co A B C D E G H 1 February 25 Close February 24 Volu

> Write a formula that will store the exact volume for each stock in column I. Use the left side of the equation to indicate in which cell to store the formula. a. Build-A-Bear Workshop Inc. b. NETGEAR Inc. A B C D E G H 1 February 25 Close Februar

> The following is a list of the number of mobile electronic devices owned by the four members of Valley High School’s Board of Education. 7, 5, 2, 3 If all samples of size 2 are taken with replacement, determine if the standard deviation is an unbiased es

> Isaac follows the market action of Google Inc. He has watched the prices for 2 consecutive days. The information he collected is given in the table. Do the September 23 numbers reflect a positive or negative money flow? Explain. Date High Low Close

> Grand Central High School has an enrollment of 2,170 students. They are taking a sample of 200 students to survey them about a proposed school policy. Rather than take a simple random sample, they want the sample to have the same percentage breakdown of

> The Bloom Biscuit Company is planning a marketing strategy for the upcoming year. They plan on doing a survey to see how many residents in their state bake. Marketing assistants randomly call homes during their 9:00 a.m.–5:00 p.m. work shift, and find ou

> Interpret the quote in terms of what you have learned about the importance of sampling to marketing.

> Which of the following is a true statement? Explain your reasoning. The 52-week high can never be higher than the day’s high. The day’s high can never be higher than the 52-week high.

> If the April 23 net change for Toyota was 10.79, what was the closing price for that day? Low 52-Week High 52-Week Low Symbol 198,600 Stock Last Change Volume High 232,420 BRK-A Berkshire 199,740 +35 186 198,800 198,700 Hathaway 51.44 38.06 VZ Veriz

> On April 22, which stock(s) had a 52-week high that was approximately 30% higher than the 52-week low? Low 52-Week High 52-Week Low Symbol 198,600 Stock Last Change Volume High 232,420 BRK-A Berkshire 199,740 +35 186 198,800 198,700 Hathaway 51.44 3

> Arianna deposits $500 in an account that pays 1.3% interest, compounded semi-annually. How much is in the account at the end of 2 years?

> Use the information from Exercise 5 to determine the percent of net change from April 21 to April 22 for each of the corporations listed in that question. Round answers to the nearest tenth of a percent. Low 52-Week High 52-Week Low Symbol 198,600 S

> Determine the closing price on April 21 for each of the following stocks. a. Delta Airlines b. Verizon Low 52-Week High 52-Week Low Symbol 198,600 Stock Last Change Volume High 232,420 BRK-A Berkshire 199,740 +35 186 198,800 198,700 Hathaway 51.4

> Rewrite the volume for each of the following stocks as “sales in 100s.” a. Berkshire Hathaway Inc. b. McDonald’s Corp c. Verizon d. Toyota Low 52-Week High 52-Week Low Symbol 198,600 Stock L

> During the baby boomer years, approximately 76 million Americans were born. Now, more than 10,000 Americans turn 65 every day. By 2030, there will be more than 1 million 100-year-olds in this country. Examine these population figures and estimates about

> What is the difference between the day’s high and low prices for McDonald’s Corp? Low 52-Week High 52-Week Low Symbol 198,600 Stock Last Change Volume High 232,420 BRK-A Berkshire 199,740 +35 186 198,800 198,700 H

> What was the difference between the 52-week high and 52-week low price for one share of Delta Airlines? Low 52-Week High 52-Week Low Symbol 198,600 Stock Last Change Volume High 232,420 BRK-A Berkshire 199,740 +35 186 198,800 198,700 Hathaway 51.44

> Write a formula that will convert the volume given in 1,000s into a volume given in 100s. Use the left side of the equation to indicate in which cell to store the formula. a. Intel Corp b. Yahoo! Inc. A B C D E G H 1 February 25 Close February 24

> On February 26, Berkshire Hathaway closed at $197,690 per share. One year earlier, one share closed at $223,970. What was an approximate 1-year percent change? A B C D E G H 1 February 25 Close February 24 Volume in Close Volume in Symbol Stock Chan

> At the end of the trading day on April 25, Riveters Inc. closed at $28.84, which was a 15.22% net change from the previous day’s close. What was the approximate close on the previous day?

> Why might the buyer and seller of the same stock both think that their trading price was an “astute” decision? How might those words apply to what you have learned? Low 52-Week High 52-Week Low Symbol 198,600 Stoc

> Elizabeth is a landscape designer. She designed a small pond with a fountain that her company plans to manufacture and market. It is a free-form shape, and the company wants to include the area of the pond on the packaging. a. She takes a model of the p

> Suppose that $1,000 is deposited into an account that yields 0.85% interest, compounded annually. How much money will be in that account at the end of 4 years?

> Giuliana is having one wall of her den covered in brick. She needs to find the area of the wall, excluding the doors and the windows. A diagram of the walls is shown. a. Giuliana creates a scale drawing to bring to the contractor. She uses the scale &A

> A gazebo in the shape of a regular hexagon (six sides) has side length s and apothem a. If the cost per square unit of flooring is c, express the total cost T of the floor algebraically.

> Google is derived from the number googol, which is a 1 with 100 zeros following it. This is equivalent to 10100. Despite the original accidental change in spelling (but not pronunciation), the name still elicits the idea of something very large. How larg

> A rectangular room measures x feet by y feet, where x , y. The ceiling is c feet high. The walls and the ceiling will be painted the same color. a. Express the area of the smaller wall and the larger wall algebraically. b. Express the total area of the

> A gazebo in the shape of a regular octagon has equal sides of 9 feet and an apothem of 10.9 feet. a. If one side of a gazebo is open and the other sides have a railing, find the cost of the railing if it sells for $7.90 per foot. b. Find the area of the

> A rectangular room is 14 feet by 20 feet. The ceiling is 8 feet high. a. Find the length and width of the smaller wall. b. Find the area of the smaller wall. c. Find the area of the larger wall. d. Find the total area of the four walls in the room.

> A rectangular room has length L and width W, where L and W are measured in feet. a. Express the area in square feet algebraically. b. If carpeting costs x dollars per square yard, express the cost of carpeting this room algebraically.

> A rectangular room measures 13 feet by 15 feet. It is going to be carpeted with carpeting that sells for $68 per square yard. a. What is the area of the room in square feet? b. If the scale of the room drawing is ¼ inch 5 1 foot, give the dimensions of

> Tom earns $15.50 per hour at the Yankee Bowling Alley. He regularly works 40 hours per week. He is paid time-and-a-half for each hour of overtime work. Last week he worked 42 hours. What was his gross pay for the week?

> Amy regularly works 20 hours per week at Pook’s Dry Cleaners from Monday through Friday. She earns $15.50 per hour and receives double-time pay for working Sundays. Next week she will work her regular 20 weekday hours, and an additional 8 hours on Sunday

> Many people claim that once they are married, they pay more taxes than they did before they were married. Many call this a marriage penalty. Suppose that Leni and Thom are lawyers and each has a taxable income of $230,000. They can’t de

> Use the graph of a piecewise function with three equations. a. A taxpayer has a taxable income of $39,800. What is her tax? b. A taxpayer will owe $21,197. What is his taxable income? c. What is the approximate tax for an income of $30,000? d. W

> At the beginning of the chapter, you were given the weights of the heaviest buildings ever moved. The Fu Gang Building in China was quoted in metric tons. A metric ton is about 10% heavier than an English standard ton. Let’s try to get a feeling for how

> Examine Schedule Y-2. Let x represent the taxable income and y represent the tax. a. What is the calculator keystroke sequence for an equation that models the tax on the interval over 37,450 but not over 75,600? b. What is the calculator keystroke seq

> Examine the following Section C tax computation worksheet. Let x represent the taxable income and y represent the tax. a. Let Y1 represent the graphing calculator function for taxable incomes on the interval over $100,000 but not over $115,225. Write t

> Elizabeth (from Exercise 9) is designing another backyard pond for her company. She follows the same procedure to find the area. She first creates an x by y rectangle to frame her pond design. She generates 10,000 random points inside the rectangle and p

> Interpret the quote in the context of what you think the difference is between a house and a home.

> Use the Section D tax computation worksheet for a head-of-household taxpayer. Let x represent the taxpayer’s taxable income and y represent the tax. Express each line of the worksheet as a linear equation in y = mx + b form. Use interva

> In 1998, a single taxpayer used this 1998 Schedule X. Let x represent the single taxpayer’s taxable income and y represent that taxpayer’s tax. Express the tax schedule as a piecewise function. 1998 Tax Rate Sched

> John’s weekly salary is $478.25. His employer is changing the pay period to semimonthly. a. What is John’s annual salary? b. What will John’s semimonthly salary be to the nearest cent?

> Use the 2012 Schedule Y-1 for a married taxpayer filing jointly. Write the piecewise function for the tax intervals. 2012 Tax Rate Schedule Schedule Y-1-f your filing status is Married filling jointly or qualifying widow(er) If your taxable income i

> Use the 2000 Schedule Y-1 for a married taxpayer filing jointly. Write an equation in 51 ymxb form for a taxable income in the interval over $105,950 but not over $161,450. 2000 Tax Rate Schedule Schedule Y-1- If your filing status is Married filing

> Sydney invests $100 every month into an account that pays 0.8% annual interest, compounded monthly. Benny invests $80 every month into an account that pays 2.2% annual interest rate, compounded monthly. a. Determine the amount in Sydney’s account after

> 1. Use the Tax Freedom Day data in the chapter opener to create a line graph. Let the x-axis represent the year and the y-axis represent the numerical day of the year on which Tax Freedom Day falls. (Hint: April 1 is the 91st day of a non-leap year. Apri

> Write a piecewise function to represent the tax f (x) for the first three taxable income intervals in Schedule Y-2 for a married taxpayer who is filing separately. Schedule Y-2-If your filing status is Married filling separately If your taxable inco

> Let y represent the tax and x represent the taxable income of a single taxpayer. a. Use the tax schedule to write three equations in 51 ymxb form for values of x that are greater than or equal to $200,000. b. Use the distributive property and combine

> There are seven taxable income intervals in this chart. Let x represent any taxable income. Express those intervals in tax schedule notation, compound inequality, and interval notation. Schedule X-If your filing status is Single If your taxable inco

> You are given this portion of a tax schedule from a previous year for single taxpayers with incomes over $71,950. a. Model each of the three rows as a simplified equation in y = mx + b form. b. Create an associated tax computation spreadsheet for the

> How can the quote be interpreted in light of what you have learned?

> Last year Beth’s annual salary was $38,350. This year she received a promotion and now earns $46,462 annually. She is paid biweekly. a. What was her biweekly salary last year? Round to the nearest cent. b. What is Beth’s biweekly salary this year? Roun

> Ralph earns $72,000 annually as an architect and is paid semimonthly. Alice also earns $72,000 but she is paid biweekly. a. How many more checks does Alice receive in a year when compared to Ralph? b. What is the difference between Ralph’s semimonthly

> Ceil gets paid biweekly. Her biweekly salary is $1,763.28. What is her annual salary?

> Baseball player Alex Rodriguez earned $20,000,000 in 2016. He played in 65 games. What was his salary per game to the nearest thousand dollars?

> Cynthia’s semimonthly salary is $1,371.50. What is her annual salary?

> In Really? Really! you were introduced to statistics about the American workforce. Now take a look at statistical predictions of how that workforce may look by the year 2024. According to the U.S. Department of Labor’s Bureau of Labor S

> Ed Lubbock’s Flash Card statement is below. There are entries missing. a. What is Ed’s average daily balance? b. What is Ed’s finance charge? c. What is Ed’s new balance? d. Wha

> Sean is paid biweekly. His annual salary is $42,500. What is his biweekly salary to the nearest cent?

> Yoko is paid semimonthly. How many fewer paychecks does she receive in a year compared to someone who is paid weekly?

> Lynn regularly works a 40-hour week and earns $16 per hour. She receives time-and-a-half pay for each hour of overtime she works. Last week she worked 43 hours. a. What was her regular gross pay? b. What was her hourly overtime rate? c. What was her o

> Eddie works at Beep-N-Kleen car wash. He earns $15 per hour. Last week he worked x hours at this rate. Express his gross pay algebraically.

> Hector works in a gas station and earns $15.50 per hour. Last week he worked 29 hours. What was his gross pay?

> Last year Nancy’s annual salary was x dollars. This year she received a raise of y dollars per year. She is paid semimonthly. a. Express her semimonthly salary last year algebraically. b. Express her semimonthly salary this year algebraically. c. On a

> Justin is a golf pro. He works 8 months per year, and is paid $76,000. During the winter months, he teaches golf privately and earns another $12,500. What is his average monthly salary based on his total yearly earnings?

> Interpret the quote in the context of what you’ve learned about jobs and salaries.

> When Payne removed his bank statement from the envelope, it got caught on a staple and a corner was ripped from the page. Now he cannot read his ending balance. Explain the computations he can do to find his ending balance. Payne Johnston 1234 Main

> In the Really? Really! section of this chapter on page 3, you examined how average Americans spend their leisure time. Often, when we look back at our leisure time we view it as “time well spent” because we engaged in

> The Cold Spring High School student government polled randomly selected seniors and asked them how much money they spent on gas in the last week, rounded to the nearest dollar. The following stem-and-leaf plot shows the data they collected. a. How many

> After Wade paid his May credit card bill, he still had a balance of z dollars. He made no additional payments or purchases before he received his next bill. The monthly periodic rate on this account is 2.015%. What expression represents the finance charg

> Mitzi looked up prices of 13 used Chevrolet HHR “retro” trucks in the classified ads and found these prices: $8,500, $8,500, $8,500, $9,900, $10,800, $10,800, $11,000, $12,500, $12,500, $13,000, $13,000, $14,500, and $23,000. a. Find the range. b. Fin

> Explain why you cannot find the range of a data set if you are given just the four quartiles.

> Bart needs to borrow $7,000 from a local bank. He uses the table of monthly payments on page 159 to compare the monthly payments for a 3% loan for three different periods of time. a. What is the monthly payment for a 2-year loan? b. What is the monthly

> Bill is looking for original taillights for his 1932 Ford. The prices vary depending on the condition. He finds these prices: $450, $100, $180, $600, $300, $350, $300, and $400. a. Find the four quartiles. b. Find the interquartile range. c. Find the

> The following list of prices is for a used original radio for a 1955 Thunderbird. The prices vary depending on the condition of the radio. $210, $210, $320, $200, $300, $10, $340, $300, $245, $325, $700, $250, $240, $200 a. Find the mean of the radio p

> Mason discovered that when he recorded a deposit of $75 two weeks ago, he mistakenly subtracted it from the running total in his check register. He decided that he would write a new entry after his most recent entry and add $75. Will this correct his mis

> Donna has a checking account that charges $0.15 for each check written and a monthly service charge of $9.75. Write a formula that Donna can use each month to find the fees she will be charged. Identify any variable you use in the formula.

> Use Tina Weaver’s monthly statement and check register to reconcile her account. a. What is the ending balance on the statement? b. What is the total of the outstanding deposits? c. What is the total of the outstanding withdrawals

> The facts about U.S. currency represent a colorful part of our country’s history. You can see paper currency manufactured at the Bureau of Engraving and Printing in Washington, D.C. You can learn about the artwork on our currency from library books and I

> Hannah wants to write a general formula and a comparison statement that she can use each month when she reconciles her checking account. Use the Checking Account Summary at the right to write a formula and a statement for Hannah. Checking Account Summar

> Ken filled out this information on the back of his bank statement. Find Ken’s revised statement balance. Does his account reconcile? Checking Account Summary Ending Balance ………………………………………………………... $ 197.10 Deposits ………………………………………………………………. + $ 600.00

> Robbie opens an account at a local bank by depositing $100. The account pays 2.4% interest, compounded weekly. He deposits $100 every week for 3 years. a. How much is in the account after 3 years? b. Write the future value function if x represents the

> Jill has not been able to maintain the $1,000 minimum balance required to avoid fees on her checking account. She wants to switch to a different account with a fee of $0.20 per check and a $12.50 monthly maintenance fee. Jill wants to estimate the fees f

> Rona filled out this information on her monthly statement. Find Rona’s revised statement balance. Does her account reconcile? Checking Account Summary Ending Balance ………………………………………………………… $ 725.71 Deposits ………………………………………………………………... + $ 610.00 Checks

2.99

See Answer