Mr. John Backster, a retired executive, desires to invest a portion of his assets in rental property. He has narrowed his choices to two apartment complexes, Windy Acres and Hillcrest Apartments. The anticipated annual cash inflows from each are as follows:
| Windy Crest | Hillcrest Apartments | ||
| $40,000 | 0.2 | $15,000 | 0.2 |
| 55,000 | 0.2 | 20,000 | 0.3 |
| 60,000 | 0.2 | 30,000 | 0.4 |
| 75,000 | 0.2 | 40,000 | 0.1 |
| 50,000 | 0.2 | ||
Mr. is likely to hold the apartment complex of his choice for about 25 years and will use this period for decision making purposes. Either apartment can be purchased for $140,000. Mr. Backster uses risk-adjusted discount rate approach when evaluating investments. His scale is related to the coefficient of variation ( for other types of investments, he also considers other measures).
| Coefficient of variation | Discount rate |
| 0-0.35 | 8% |
| 0.35-0.40 | 12% (Cost of Capital) |
| 0.40-0.50 | 15% |
| Over 0.50 | not considered |
a) compute the risk-adjusted net present value for Windy Acres and Hillcrest Apartments.
b) Which investment should Mr. Backster accept if the two investments are mutually exclusive? If the investments are not mutually exclusive and no capital rationing is involved, how would your decision be affected?
In: Finance
The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $50 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows:
| Procurement Cost ($) |
Probability |
Labor Cost ($) |
Probability |
Transportation Cost ($) |
Probability |
| 10 | 0.45 | 20 | 0.2 | 2 | 0.75 |
| 12 | 0.25 | 22 | 0.25 | 4 | 0.25 |
| 13 | 0.3 | 25 | 0.35 | ||
| 27 | 0.2 |
In: Operations Management
what would be the optimal asset allocation? What is the expected return on the portfolio?
Greta, an elderly investor, has a degree of risk aversion of A = 3 when applied to return on wealth over a one-year horizon. She is pondering two portfolios, the S&P 500 and a hedge fund, as well as a number of one-year strategies. (All rates are annual and continuously compounded.) The S&P 500 risk premium is estimated at 5.2% per year, with a SD of 20.2%. The hedge fund risk premium is estimated at 10.2% with a SD of 35.2%. The returns on both of these portfolios in any particular year are uncorrelated with its own returns in other years. They are also uncorrelated with the returns of the other portfolio in other years. The hedge fund claims the correlation coefficient between the annual returns on the S&P 500 and the hedge fund in the same year is zero, but Greta is not fully convinced by this claim.
a-1. Assuming the correlation between the annual returns on the two portfolios is 0.3, what would be the optimal asset allocation? (Do not round intermediate calculations. Enter your answers as decimals rounded to 4 places.)
| S&P | ? |
| Hedge | ? |
a-2. What is the expected return on the portfolio? (Do not round intermediate calculations. Enter your answers as decimals rounded to 4 places.)
| Expected return | ? |
In: Finance
Daddy Wants a Diesel or Does He?
INTRODUCTION
Rebecca shook her head and gave a loud sigh as she hung up the phone from talking with her dad.
“What is it?” her roommate Claire asked.
“Per usual, Daddy Jim wants me to use my ‘schooling,’ as he likes to call it, to help him decide whether to buy a new crew cab truck with either a diesel or a gas engine,” Rebecca replied.
“Well, maybe he will forget all about it if you just wait him out,” Claire offered.
“Oh no, you do not know him like I do. He will expect a full analysis, or I will never hear the end of it!”
“Well, maybe you will think twice before bragging to him about your examination scores in accounting after this,” Claire said.
“You got that right! I will have to get on it right after my last final, or there will be no peace over break,” Rebecca responded. THE MODELS AND ENGINES
Rebecca opened the last e-mail from her dad to find the following information he compiled about the purchase decision. Jim made it quite clear that he wanted a 4 × 4 to be able to get his boat up the steep, sandy ramp he used most frequently. His friend, Kashef, had a late-model truck that impressed Jim very much. Any truck in this class that he chose would offer standard equipment, which is a huge step up from the 2012 Scion iQ he had bought when gas surged in 2012. However, Jim was not sure whether getting the standard engine (the V6), or paying extra for the V8 or Diesel made any sense. That is where Rebecca came in.
The engine choices were a 3.6-liter V6 rated at 295 horsepower, a 3.0-liter diesel V6 rated at 240 horsepower, or a 5.7-liter V8 rated at 360 horsepower. All of the trucks were capable of pulling Jim’s boat, a 17-foot Carolina Skiff that weighed just short of 1,500 lbs. including the boat, motor, and gear.
Vehicle mileage was one issue at hand, as well as Jim’s driving habits. The V6’s Environmental Protection Agency (EPA) rating was 17 city miles per gallon (MPG) and 25 highway MPG, while the diesel was rated 21 city MPG and 29 highway MPG. The V8 was rated at 15 city MPG and 22 highway MPG. The manufacturer suggested 89 octane fuel for the V8, but Jim indicated he would use 87 octane unless engine pinging became pronounced. The manufacturer’s “Build and Price” feature indicated that the V6 came standard, but the diesel was a $4,270 option, and a V8 was a $1,250 option.
GAS AND DIESEL PRICES
In his e-mail to Rebecca, Jim said diesel usually ran $0.25 more per gallon than unleaded gas. He was not sure whether this was accurate but thought it was in the ballpark. Rebecca wondered about this, since she had never paid attention to diesel prices in her own trips to fill up. She decided to check the price differential by visiting the U.S. Energy Information Administration website. See Table for the information she found.
Without computing the averages, she noticed there was a premium for diesel compared with regular gasoline, as reported by the U.S. Energy Information Administration averages.1 Jim’s estimate of $0.25 appeared a bit high. She noted that she could obtain more specific fuel price information based on geographic location. But there was also an issue of whether the area where Jim drives was in an area requiring reformulated or conventional fuel. Because she lacked specific details and needed to get to a review session for intermediate class, Rebecca decided to use the U.S. averages.
DRIVING HABITS
Rebecca did not need an e-mail to tell her about Jim’s driving habits. He had recently commented that his current Scion iQ had topped 100,000 miles after five and a half years of ownership. He bought that car as a reaction to the spike in fuel prices in 2012 and regretted his decision ever since.
Rebecca suspected that the miles he drove per year had declined some since she and her siblings had gone off to college more than three years ago, even though they usually refused to ride in his car, because, frankly, it was embarrassing. As Rebecca graduated and went off to college and with her siblings in the Peace Corps overseas, Jim would not have to drive them around anymore, thereby reducing his mileage. Rebecca also knew that Jim and her mother would take driving vacations as they became empty nesters. She decided that Jim would continue to drive approximately 18,000 miles per year for the foreseeable future. Her best guess was that 60% of his driving was highway miles, while 40% were driven in the city.
Jim had been very thrifty throughout his life. He was a very cautious investor, even more so now that he was getting older. During Rebecca’s last trip home, he had said that he thought he could continue to earn a return on all of his investments of 3.75% per year, which was in-line with the Wall Street Journal Prime Rate. Because of his thriftiness, Jim had accumulated enough wealth to pay cash for the purchase of the new car without affecting his or Rebecca’s mom’s lifestyles.
CONCLUSION
A car horn startled Rebecca out of her automotive ruminations. She motioned to her roommate that she will be out in a minute for their well-deserved, end-of-semester dinner. Rebecca knew she would need to put her thoughts into a more usable format before heading home over break. So diesel got better mileage, but it costs more per gallon and was a large additional cost at the time of purchase. This would require more than an armchair approach. Did she have all the information she needed to perform her analysis? What approach should she use to give her dad the best information to make a decision?
QUESTIONS:
4. What might Rebecca’s solution look like?
Assumption current vehicle for 6 years and new vehicle ownership for 8 years. The given discount rate: 3.75% a year. What is the present value of saving? This is the step I'm stuck at. Please provide calculation for present value saving.
5. What recommendation should Rebecca make? How should it be presented to Jim?
Gasoline and Diesel Prices per Gallon, September 2016 to February 2017
|
Sep-16 |
Oct-16 |
Nov-16 |
Dec-16 |
Jan-17 |
Feb-17 |
||||||
|
Average U.S. Gasoline Prices, All Grades |
2.327 |
2.359 |
2.295 |
2.366 |
2.458 |
2.416 |
|||||
|
Average U.S. Diesel (Highway) Prices, All Types |
2.394 |
2.454 |
2.439 |
2.51 |
2.58 |
2.568 |
|||||
|
Adapted from: “Weekly Retail Gasoline and Diesel Prices,” U.S. Energy Information Administration, Released February 2, 2018, www.eia.gov/dnav/pet/PET_PRI_GND_DCUS_NUS_W.htm |
|||||||||||
In: Accounting
#########################PANDAS LANGUAGE##################
#########################MATPLOT LIB#########################
# read movie.csv into a DataFrame called 'movie' # describe the dataframe #rename the column Runtime (Minutes) with Runtime_Minutes, and Revenue (Millions) with Revenue_Millions
# show if any column has null value
# count total number of null vlaues in the dataframe
# print those rows which has null values
# fill null values,
#if column is numerical than fill with means (if there is no numerical missing value in
#data frame then don't code in this)
#if column is categorical than fill with most frequent value (if there is no categorical missing value in
#data frame then don't code in this)
# plot histogram of the column name year in movie dataframe, which shows how many movies release in a year.
# print the movie detail with title 'Grumpier Old Men'.
# show those movies which are released after 1995-01-01
# sort the movie DataFrame in decending order based on release_date
# for each year, display the total number of movie with specific gerne for example Action=1000,adventure=400
# plot histogram the upper calculated total count
# filter the movies with specific gerne # like show only those movies which are selected Action gerne
# filter the movies with specific gerne
# like show only those movies which are selected Action gerne
# for each Director, display all the movies with detail.
# count the movies and plot barchart top 10 director's movies.
# for each Actor, display all the movies with detail.
# count the movies and visualize the top 10 actor's movies in plot
In [27]:
data file
| Rank | Title | Genre | Description | Director | Actors | Year | Runtime (Minutes) | Rating | Votes | Revenue (Millions) | Metascore | |
| 1 | Guardians of the Galaxy | Action,Adventure,Sci-Fi | A group of intergalactic criminals are forced to work together to stop a fanatical warrior from taking control of the universe. | James Gunn | Chris Pratt, Vin Diesel, Bradley Cooper, Zoe Saldana | 2014 | 121 | 8.1 | 757074 | 333.13 | 76 | |
| 2 | Prometheus | Adventure,Mystery,Sci-Fi | Following clues to the origin of mankind, a team finds a structure on a distant moon, but they soon realize they are not alone. | Ridley Scott | Noomi Rapace, Logan Marshall-Green, Michael Fassbender, Charlize Theron | 2012 | 124 | 7 | 485820 | 126.46 | 65 | |
| 3 | Split | Horror,Thriller | Three girls are kidnapped by a man with a diagnosed 23 distinct personalities. They must try to escape before the apparent emergence of a frightful new 24th. | M. Night Shyamalan | James McAvoy, Anya Taylor-Joy, Haley Lu Richardson, Jessica Sula | 2016 | 117 | 7.3 | 157606 | 138.12 | 62 | |
| 4 | Sing | Animation,Comedy,Family | In a city of humanoid animals, a hustling theater impresario's attempt to save his theater with a singing competition becomes grander than he anticipates even as its finalists' find that their lives will never be the same. | Christophe Lourdelet | Matthew McConaughey,Reese Witherspoon, Seth MacFarlane, Scarlett Johansson | 2016 | 108 | 4.2 | 60545 | 270.32 | 59 | |
| 5 | Suicide Squad | Action,Adventure,Fantasy | A secret government agency recruits some of the most dangerous incarcerated super-villains to form a defensive task force. Their first mission: save the world from the apocalypse. | David Ayer | Will Smith, Jared Leto, Margot Robbie, Viola Davis | 2015 | 123 | 3.2 | 393727 | 325.02 | 40 | |
| 6 | The Great Wall | Action,Adventure,Fantasy | European mercenaries searching for black powder become embroiled in the defense of the Great Wall of China against a horde of monstrous creatures. | Yimou Zhang | Matt Damon, Tian Jing, Willem Dafoe, Andy Lau | 2014 | 103 | 6.1 | 56036 | 45.13 | 42 | |
| 7 | La La Land | Comedy,Drama,Music | A jazz pianist falls for an aspiring actress in Los Angeles. | Damien Chazelle | Ryan Gosling, Emma Stone, Rosemarie DeWitt, J.K. Simmons | 2013 | 128 | 5.3 | 258682 | 151.06 | 93 | |
| 8 | Mindhorn | Comedy | A has-been actor best known for playing the title character in the 1980s detective series "Mindhorn" must work with the police when a serial killer says that he will only speak with Detective Mindhorn, whom he believes to be a real person. | Sean Foley | Essie Davis, Andrea Riseborough, Julian Barratt,Kenneth Branagh | 2010 | 89 | 6.4 | 2490 | 71 | ||
In: Computer Science
11. In the 5-Stage DuPont ROE formula, which of the following is considered a utilization ratio:
a. NI / EBT or the tax burden ratio
b. EBT / EBIT or the interest burden ratio
c. EBIT / Sales or the operating margin
d. Sales / TA or total asset turnover ratio
e. TA / SE or the leverage ratio
12. During lecture and on the lecture slides, we evaluated Vulcan Materials’ operating margin over a full 10 year business cycle. Because Vulcan Materials’ operating margin ________ when economic conditions deteriorate (e.g. during the housing crisis), Vulcan Material’s would best be categorized as a ________.
a. decreases ; cyclical company
b. increases ; cyclical company
c. decreases ; non-cyclical company
d. increases ; non-cyclical company
e. increases ; counter-cyclical company
13. You owe your credit company $25,000 and plan to make no payments on your credit card for 1.0 year. Due to your current credit score, your credit card company charges you an APR of 30.0%. If, however, you took measures to increase your credit score by 100points, your credit card company would instantaneously adjust your APR by 5.0%. How much would you save over 1.0 year if you took actions to increase your credit score?
a. $1,525
b. $1,603
c. $1,677
d. $8,622
e. $8,717
14. You are the beneficiary of a trust set up by your grandparents. You will receive a total of 60 after tax cash flows ($1,000 each) beginning six years from now (T=6) when you turn age 25. These payments are intended to help cover your living expenses over the course of your expected lifetime. Assume the appropriate discount rate is 6.0% per annum. What is the present value of the 60 payments?
a. $11,372
b. $11,393
c. $12,077
d. $12,098
e. $16,667
15. You have $1000 in a savings account today (T=0). Approximately how much longer would it take for your investment to double (i.e. to become worth $2000) if you earned 4.0% on your savings as opposed to 12.0% at the end of every calendar year? Hint: Think Rule of 72.
a. 6 years
b. 8 years
c. 12 years
d. 16 years
e. 18 years
In: Finance
Using Minitab, use the regression model with all nine independent variables to test the hy- potheses H0 : βAGE = −2500 vs. Ha : βAGE < −2500. Use α = 0.05 and include all steps of a hypothesis test.
Row PRICE BATHS
BEDA BEDB BEDC CARA
CARB AGE LOT
DOM
1 25750 1.0 1
0 0 1 0
23 9680 164
2 37950 1.0 0
1 0 0 1
7 1889 67
3 46450 2.5 0
1 0 0 0
9 1941 315
4 46550 2.5 0
0 1 1 0
18 1813 61
5 47950 1.5 1
0 0 0 1
2 1583 234
6 49950 1.5 0
1 0 0 0
10 1533 116
7 52450 2.5 0
0 1 0 0
4 1667 162
8 54050 2.0 0
1 0 0 1
5 3450 80
9 54850 2.0 0
1 0 0 0
5 1733 63
10 52050 2.5 0
1 0 0 0
5 3727 102
11 54392 2.5 0
1 0 0 0
7 1725 48
12 53450 2.5 0
1 0 0 0
3 2811 423
13 59510 2.5 0
1 0 0 1
11 5653 130
14 60102 2.5 0
1 0 0 0
7 2333 159
15 63850 2.5 0
0 1 0 0
6 2022 314
16 62050 2.5 0
0 0 0 0
5 2166 135
17 69450 2.0 0
1 0 0 0
15 1836 71
18 82304 2.5 0
0 1 0 0
8 5066 338
19 81850 2.0 0
1 0 0 0
0 2333 147
20 70050 2.0 0
1 0 0 0
4 2904 115
21 112450 2.5 0
0 1 0 0
1 2930 11
22 127050 3.0 0
0 1 0 0
9 2904 36
In: Statistics and Probability
/ File: temperature.cxx
// This program prints a table to convert numbers from one unit to
another.
// The program illustrases some implementation techniques.
#include // Provides cout
#include // Provides setw function for setting output width
#include // Provides EXIT_SUCCESS
#include // Provides assert function
using namespace std; // Allows all standard library items to be
used
double celsius_to_fahrenheit(double c)
// Precondition: c is a Celsius temperature no less than
absolute
// zero (-273.16).
// Postcondition: The return value is the temperature c converted
to Fahrenheit
// degrees.
{
const double MINIMUM_CELSIUS = -273.16; // Absolute zero in Celsius
degrees
assert(c >= MINIMUM_CELSIUS);
return (9.0 / 5.0) * c + 32;
}
void setup_cout_fractions(int fraction_digits)
// Precondition: fraction_digits is not negative.
// Postcondition: All double or float numbers printed to cout will
now be
// rounded to the specified digits on the right of the
decimal.
{
assert(fraction_digits > 0);
cout.precision(fraction_digits);
cout.setf(ios::fixed, ios::floatfield);
if (fraction_digits == 0)
cout.unsetf(ios::showpoint);
else
cout.setf(ios::showpoint);
}
int main( )
{
const char HEADING1[] = " Celsius"; // Heading for table's 1st
column
const char HEADING2[] = "Fahrenheit"; // Heading for table's 2nd
column
const char LABEL1 = 'C'; // Label for numbers in 1st column
const char LABEL2 = 'F'; // Label for numbers in 2nd column
const double TABLE_BEGIN = -50.0; // The table's first Celsius
temp.
const double TABLE_END = 50.0; // The table's final Celsius
temp.
const double TABLE_STEP = 10.0; // Increment between
temperatures
const int WIDTH = 9; // Number chars in output numbers
const int DIGITS = 1; // Number digits right of decimal pt
double value1; // A value from the table's first column
double value2; // A value from the table's second column
// Set up the output for fractions and print the table
headings.
setup_cout_fractions(DIGITS);
cout << "CONVERSIONS from " << TABLE_BEGIN << "
to " << TABLE_END << endl;
cout << HEADING1 << " " << HEADING2 <<
endl;
// Each iteration of the loop prints one line of the table.
for (value1 = TABLE_BEGIN; value1 <= TABLE_END; value1 +=
TABLE_STEP)
{
value2 = celsius_to_fahrenheit(value1);
cout << setw(WIDTH) << value1 << LABEL1 <<
" ";
cout << setw(WIDTH) << value2 << LABEL2 <<
endl;
}
return EXIT_SUCCESS;
}
1) The source code must be well structured like include relevant comments like on the top include the version like 1.0 and 1.1, date, and a brief description of what the program does.
2) . As you make changes you
can add one line description of the changes and change the version
# or add a version #
like version 1.0 and 1.1
3) Write a short report (not to exceed 100 words) that describes the work done, the input, and output when executing the program.
In: Computer Science
12. In a solution, when the concentrations of a weak acid and its conjugate base are equal,….
[A] the system is not at equilibrium
[B] the -log of the [H+] and the -log of the Ka are equal
[C] the buffering capacity is significantly decreased
[D] the buffering capacity is significantly increased
[E] All of the above are true.
13. The concentration of iodide ions in a saturated solution of lead (II) iodide is ________ M.
The solubility product constant of PbI2 is 1.4 x 10-8.
[A] 1.4 x 10-8 [B] 1.5 x 10-3 [C] 3.5 x 10-9 [D] 3.8 x 10-4 [E] 3.0 x 10-3
14. The solubility of lead (II) chloride (PbCl2) is 1.6 x 10-2 M. What is the Ksp of PbCl2?
[A] 4.1 x 10-6 [B] 1.6 x 10-5 [C] 3.1 x 10-7 [D] 5.0 x 10-4 [E] 1.6 x 10-2
15. The solubility of manganese (II) hydroxide (Mn(OH)2) is 2.2 x 10-5 M. What is the Ksp of
Mn(OH)2?
[A] 2.2 x 10-5 [B] 2.1 x 10-14 [C] 1.1 x 10-14 [D] 4.8 x 10-10 [E] 4.3 x 10-14
16. Which of these expressions correctly expresses the solubility-product constant for
Ag3PO4 in water?
[A] [Ag][PO4] [B] [Ag+][PO43−] [C] [Ag+]3[PO43−]
[D] [Ag+][PO43−]3 [E] [Ag+]3[PO43−]3
17. A solution of NaF is added dropwise to a solution that is 0.0166 M in Ba2+. When the
concentration of F- exceeds ________ M, BaF2 will precipitate. Neglect volume changes.
For BaF2, Ksp = 1.7 ⋅ 10-6.
[A] 1.0 x 10-2 [B] 1.0 x 10-4 [C] 5.1 x 10-5 [D] 2.5 x 10-3 [E] 2.8 x 10-8
18. A solution contains 2.3 x 10-4 M Ag+ and NaI solution is being added drop wise. What
is the minimum concentration of I- to begin precipitation of AgI? Ksp (AgI)= 8.3 x 10-17
[A] 8.32 x10-17 M [B] 2.51 x 10-17 M [C] 3.01 x 10-15
[D] 3.51 x 10-14 M [E] 3.61 x 10-13 M
In: Chemistry
Program Requirements:
This assignment requires you to create one program in
Java to simulate a Point-of-Sale (POS) system. The
solution must be in JAVA language.
You create the main program called POSmain.java and two classes:
ShoppingCart and CashRegister.
Your POSmain program should take three file names from command line
arguments. The first file contains a list of products and their
prices; the second and third files are lists of items in two
shopping carts of two customers. The POSmain program should first
read the price file, then read each of the cart files to load a
list of items in a shopping cart and store them in a ShoppingCart
objects. The price file may contain a variable number of products
and the cart files may contain a variable number of items.
POSmain then will create a CashRegister object by passing the price
list to it. The POSmain program then will use the CashRegister
object to scan items in a cart and print a receipt for each
shopping cart one by one. At last, POSmain will use the
CashRegister object to print a report for the day.
The students will the report for the day, which requires design of
your CashRegister class.
cart1.txt:
TV
Table
Table
Bed
Bed
Chair
Chair
Chair
Chair
cart2.txt:
Milk
Butter
Tomato
Tomato
Tomato
Tomato
Tomato
Onion
Onion
Onion
Lettuce
Milk
Ham
Bread
Bread
price.txt:
TV
999.99
Table 199
Bed 499.99
Chair 45.49
Milk 3.00
Butter 2.84
Tomato 0.76
Onion 0.54
Lettuce 1.00
Ham 2.50
Bread 1.75
Program Output:
One customer is checking out ...
========================================
Product Price Qty Subtotal
----------------------------------------
Bed $499.99 2 $999.98
Char $45.49 4 $181.96
TV $999.99 1 $999.99
Table $199.0 2 $398.0
-------------------------
Total $2579.93
========================================
One customer is checking out ...
========================================
Product Price Qty Subtotal
----------------------------------------
Bread $1.75 2 $3.5
Butter $2.84 1 $2.84
Ham $2.5 1 $2.5
Lettuce $1.0 1 $1.0
Milk $3.0 2 $6.0
Onions $0.54 3 $1.62
Tomato $0.76 5 $3.8
-------------------------
Total $21.26
========================================
Report for the day
========================================
Number of customers: 2
Total sale: $2601.19
List of products sold:
----------------------------------------
Product Qty
----------------------------------------
Bed 2
Bread 2
Butter 1
Char 4
Ham 1
Lettuce 1
Milk 2
Onions 3
TV 1
Table 2
Tomato 5
In: Computer Science