The following table exhibits the age of antique furniture and the corresponding prices. Use the table to answer the following question(s). (Hint: Use scatter diagram and the Excel Trendline tool where necessary).

What is the expected value for a 90 year-old piece of furniture?

a. $934.56

b. $1029.36

c. $1002.45

d. $1033.21

4. (a) Describe and explain “Tragedy of the Commons”. What implications does it have on the pollution problems in terms of whom to be assigned the responsibility of “fixing” it? (b) Apply “tragedy of the commons” to the BP Oil Spill in the Gulf of Mexico in 2010. Explain why it happened (to the extent that it did) and what could have been done (prior to the incident) that could have reduced the probability of it happening. (c) After the incident, Obama vowed to fix this. He ordered a moratorium (temporary suspension of ALL oil rigs in the Gulf). Who does this moratorium benefit?

QUESTION 20

1. Carrie, after selling all of her shares of DD Company, decided to transact in a mutual fund in January 1, 2010. She listed the fund’s returns over a three-year period as shown below:

2. Based on these data, the money-weighted return for the investor is closest to:

Suppose you are given the following end of year stock price data for Random Inc. stock. Assume the returns are normally distributed, calculate the probability that an investor will earn more than 1.5% in a given year (e.g. Prob(Ret>1.5%)). (Enter percentages as decimals and round to 4 decimals). Year Price 2005 50.25 2006 66.49 2007 79.72 2008 83.81 2009 88.38 2010 84.39 2011 91.1 2012 82.17 2013 86.39 2014 76.35 2015 85.47 2016 86.07

Create a class called Car (Car.java). It should have the following private data members:

• String make

• String model

• int year

Provide the following methods:

• default constructor (set make and model to an empty string, and set year to 0)

• non-default constructor Car(String make, String model, int year)

• getters and setters for the three data members

• method print() prints the Car object’s information, formatted as follows:

Make: Toyota

Model: 4Runner

Year: 2010

public class Car {

}

Jason is interested in buying a new Maserati Gibli. The sales price of the car is $77,000. Jason intends to put a down payment of $15,000 and take up the balance with a 5 year loan. Since Jason has excellent credit, he anticipates the annual interest rate (APR) for his future loan would be 2.84%. Round your answers to the nearest dollar.

The maximum down payment Jason can afford is $30,000. Construct a one-way data table with the down payment amount as the column input and monthly payment as the output. Vary the down payment amount between $0 and $30,000 in increments of $5,000. What is the range of payments that Jason is expecting?

After thinking about the future loan, Jason decides he only wants to pay $900 per month. Using the appropriate Excel tool, find the exact down payment amount that Jason needs.

Please show how to solve all problems using Excel, and please show how to construct the one way data table.

You are 20 years old and plan to purchase a house when you are 35

.a. The current price of the house you want to purchase is $275,000 and the price is expected to increase by 3% per year. How much will the house cost when you are 35?

b. When you are 35, the bank will require a cash down-payment of 10% of the house price to obtain a mortgage. How much will you need to save each year between age 20 and 35 to have enough for the down-payment, if you can earn 5% on your deposits? Assume end-of-year deposits.

c. Given the same data in part b., how much will you need to deposit each year to have enough for the down-payment if you make beginning-of-year deposits?

d. Suppose your parents promise to pay the down-payment when you turn 35. How much will they need to deposit today in an account that will earn 8% for the next 15 years (when you will need to the down-payment)?

Let’s say you push the block from the bottom of the plane all the way up to the top of the plane, then let it slide back down.

11-1. While you are pushing the block up the plane, is the work done by gravity positive or negative? Why?

11-2. While you are pushing the block up the plane, is the work done by friction positive or negative? Why?

11-3. As the block slides back down the plane, is the work done by gravity positive or negative?

11-4. As the block slides back down the plane, is the work done by friction positive or negative?

11-5. What is the net work done by gravity over the entire cycle (being pushed all the way up and then sliding all the way back down)? Is it positive, negative, or zero?

11-6. What is the net work done by friction over the entire cycle (being pushed all the way up and then sliding all the way back down)? Is it positive, negative, or zero?

Time Value of Money Concept

The following situations involve the application of the time value of money concept. Use the full factor when calculating your results.

Use the appropriate present or future value table:

FV of $1, PV of $1, FV of Annuity of $1 and PV of Annuity of $1

1. Janelle Carter deposited $9,610 in the bank on January 1, 2000, at an interest rate of 15% compounded annually. How much has accumulated in the account by January 1, 2017? Round to the nearest whole dollar.
$__________

2. Mike Smith deposited $23,480 in the bank on January 1, 2007. On January 2, 2017, this deposit has accumulated to $42,049. Interest is compounded annually on the account. What rate of interest did Mike earn on the deposit? Round to the nearest whole percent.
__________ %

3. Lee Spony made a deposit in the bank on January 1, 2010. The bank pays interest at the rate of 10% compounded annually. On January 1, 2017, the deposit has accumulated to $17,750. How much money did Lee originally deposit on January1, 2010? Round to the nearest whole dollar.
$_________

4. Nancy Holmes deposited $4,740 in the bank on January 1 a few years ago. The bank pays an interest rate of 8% compounded annually, and the deposit is now worth $9,475. How many years has the deposit been invested? Round to the nearest whole year.
_________years