You just bought a new car. You chose this brand because they are famous for holding their value. In fact, your model only depreciates at 3% per year. If you paid $37,000 for your car and you are planning on keeping it for 10 years, how much will it be worth when you trade it in?  $

If you use TVMSolver to solve these questions, be sure and show your inputs in your written work so you can get full credit. State your answers to the nearest cent. Sara has created a budget for her retirement and would like to have a retirement income of $3500 per month. She is hoping to live for 30 years in retirement. Her 401K earns 7.5% per year compounded monthly. A) How much money will she need to have in her account at retirement? [PV] B) If she is planning on working for 25 years before retiring, how much must she put into her account each month to make sure she reaches her goal? [PMT]

The manager of Bill’s Bicycles has found that he can sell 100 bicycles if he sets the price at $125 and he can sell 200 bicycles if he sets the price at $100. (A) Write the linear demand function for the bicycle shop. q = [demand] (B) Interpret the slope of the demand function:      “For each [inc1] increase in price, the demand (increases/decreases) [delta] by [q] bicycles.” (C) If the supply function is

In order to receive credit for this exam, you must agree to abide by the following honor code. While taking this exam, you are allowed to use a non-CAS calculator (graphing or scientific). You are expected to use the techniques you learned in class to solve problems, writing your solutions legibly, and labeling each solution with the problem number. You may use a 3×5 index card for formulas that we have used in this course. It must be handwritten and may not include any worked-out examples. You are NOT allowed: To use videos, books, or other materials from class. To get help from others or give help to others. No collaboration is permitted. to use other websites or phone apps.  I agree to follow the exam policy stated above. All of the work I submit will be my own. (T/F)

If you use TVMSolver to solve these questions, be sure and show your inputs in your written work so you can get full credit. State your answers to the nearest cent. Sara has created a budget for her retirement and would like to have a retirement income of $3500 per month. She is hoping to live for 30 years in retirement. Her 401K earns 7.5% per year compounded monthly. A) How much money will she need to have in her account at retirement? [PV] B) If she is planning on working for 25 years before retiring, how much must she put into her account each month to make sure she reaches her goal? [PMT]

The manager of Bill’s Bicycles has found that he can sell 100 bicycles if he sets the price at $125 and he can sell 200 bicycles if he sets the price at $100. (A) Write the linear demand function for the bicycle shop. q = [demand] (B) Interpret the slope of the demand function:      “For each [inc1] increase in price, the demand (increases/decreases) [delta] by [q] bicycles.” (C) If the supply function is

If you use TVMSolver to solve these questions, be sure and show your inputs in your written work so you can get full credit. State your answers to the nearest cent. You decide to take out a 30-year fixed rate mortgage to buy your new home. You are going to borrow $400,000 at an interest rate of 2.25%. (A) Calculate your monthly payment. $ [pmt] (B) How much total interest will you pay over the life of the loan? $ [int] 

Grab your mirror and reflect your workspace, keyboard, left side, right side, and in front of your keyboard using your mirror.  Spend no more than 30 seconds here but make sure that the reflection is clear and hits the target areas.  Do NOT move anything else other than the mirror Do NOT leave the view of the camera or lean out of view Once done, place the mirror back down, click ‘Mirror reflection is complete’ and go to the NEXT question.  

 employee_id |    date    | job_title_id | salary ————-+————+————–+——–           1 | 2020-01-01 |            1 |  50000           1 | 2020-06-01 |            2 |  45000           2 | 2020-01-01 |            1 |  50000           3 | 2020-01-01 |            1 |  50000           4 | 2020-01-01 |            2 |  45000           5 | 2020-01-01 |            2 |  45000(6 rows) Assume that the two following transactions are happening concurrently on the above table called employee_salary in Postgres. What is the output of “SELECT date FROM employee_salary WHERE employee_id = 2;” in (7), if each statement is performed in the order in the parenthesis?   BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; –(2)SELECT * FROM employee_salary; –(3)UPDATE  employee_salary SET date = ‘2020-03-01’ WHERE employee_id = 2; –(5)SELECT date FROM employee_salary WHERE employee_id = 2; –(7)COMMIT; –(8) BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; ; –(1)UPDATE employee_salary SET date = ‘2020-02-01’ WHERE employee_id = 2; –(4)COMMIT; –(6)

CREATE TABLE employee_salary (     employee_id NUMERIC,    date DATE,    job_title_id NUMERIC,    salary NUMERIC,    PRIMARY KEY (employee_id, date)); employee_id |    date    | job_title_id | salary ————-+————+————–+——–           1 | 2020-01-01 |            1 |  50000           1 | 2020-06-01 |            2 |  45000           2 | 2020-01-01 |            1 |  50000           3 | 2020-01-01 |            1 |  50000           4 | 2020-01-01 |            2 |  45000           5 | 2020-01-01 |            2 |  45000(6 rows) For the above table definition, what is the output of the last query, “SELECT COUNT(*) FROM employee_salary WHERE employee_id = 2; ” in the following transaction? BEGIN;INSERT INTO employee_salary VALUES (2, ‘2020-01-01’, 2,45000);COMMIT;SELECT COUNT(*) FROM employee_salary WHERE employee_id = 2;