Questions
Q1) Please create a C++ program that will ask the user for how many test scores...
Q1) Please create a C++ program that will ask the user
for how many test scores will be entered. Setup a while loop with
this loop iteration parameter. The data will include the student’s
first name, Wayne State Access ID, midterm score and their favorite
team (i.e. – Doug, hg1702, 92, Wolverines * - John, hv2201, 99,
Warriors). Print out the completed test scores to a file
(midTermScores.txt) . Adjust the output as follows: (15
points)
a. Scores with the highest grade should be listed first as in
ascending order.
b. A letter grade should be in place of the numeric score using
standard grading (a = 90 – 100, b=80-90, c=70-80, d=60-70, f=below
60)
c. The fields should be displayed with a total width of 15.
d. The fields should be printed with a header in the file
explaining what each is:
i. First Name Access ID Test Score Favorite Team
ii. John hv2201 A Warriors
iii. Doug hg1702 A Wolverines
Q2) Please create a program that will ask a high school group that
is made of 5 to 17 students to sell candies for a fund raiser.
There are small boxes that sell for $7 and large ones that sell for
$13. The cost for each box is $4 (small box) and $6 (large box).
Please ask the instructor how many students ended up participating
in the sales drive (must be between 5 and 17). The instructor must
input each student’s First name that sold items and enter the
number of each box sold each (small or large). Calculate the total
profit for each student and at the end of the program, print how
many students participated and the total boxes sold for each (small
and large) and finally generate how much profit the group made. (15
points)
In: Computer Science
The transactions relating to the formation of Blue Co. Stores Inc., and its first month of...
The transactions relating to the formation of Blue Co. Stores Inc., and its first month of operations follow.
- The firm was organized and the stockholders invested cash of $8,700.
- The firm borrowed $5,500 from the bank; a short-term note was signed.
- Display cases and other store equipment costing $1,750 were purchased for cash. The original list price of the equipment was $1,940, but a discount was received because the seller was having a sale.
- A store location was rented, and $1,400 was paid for the first month's rent.
- Inventory of $16,000 was purchased; $8,200 cash was paid to the suppliers, and the balance will be paid within 45 days.
- During the first week of operations, merchandise that had cost $3,900 was sold for $5,800 cash.
- A newspaper ad costing $120 was arranged for; it ran during the second week of the store's operations. The ad will be paid for in the next month.
- Additional inventory costing $4,250 was purchased; cash of $1,350 was paid, and the balance is due in 30 days.
- In the last three weeks of the first month, sales totaled $13,750, of which $9,100 was sold on account. The cost of the goods sold totaled $9,200.
- Employee wages for the month totaled $2,000; these will be paid during the first week of the next month.
- The firm collected a total of $3,450 from the sales on account recorded in transaction i.
- The firm paid a total of $4,900 of the amount owed to suppliers from transaction e.
Required:
- Record each transaction in the appropriate columns. Indicate the financial statement effect.
- Calculate the total assets, liabilities, and stockholders' equity at the end of the month and calculate the amount of net income for the month.
- After completing parts a through l, prepare an income statement for Blue Co. Stores Inc. for the month presented and a balance sheet at the end of the month.
In: Accounting
Complete the following tasks. In each exercise, represent your answer only in DBDL. Do not use...
Complete the following tasks. In each exercise, represent your answer only in DBDL. Do not use diagrams a this point. Submit either a text file or a Word document with your work. Make sure you follow chapter 6's DBDL notation
(****** Just to clarify: this is the first question on Page
220. It says to 'produce the following reports', but what you are
asked to do is use DBDL notation to create 5 tables: Guide,
Trip, Customer, Reservation and TripGuides
Make sure to list the FK where they belong ******)
- Design a database to produce the following reports. Do
not use any surrogate keys in your design.
- For each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired.
- For each trip, list the trip ID number, the trip name, the location from which the trip starts, the state in which the trip originates, the trip distance, the maximum group size, the type of trip (hiking, biking, or paddling), the season in which the trip occurs, and the guide number, first name, and last name of each guide. A guide may lead many trips and a trip may be led by many differen't guides.
- For each customer, list the customer number, customer last name, customer first name, address, city, state, postal code, and telephone number.
- For each reservation, list the trip ID number, the trip date, the number of persons included in the reservation, the price of the trip per person, the total of any additional fees per person, and the customer number, first name, and last name of the customer who made the reservation.
In: Computer Science
ACCY 415 Individual Assignment #1 Assume you have graduated from college, are earning a steady income...
ACCY 415
Individual Assignment #1
Assume you have graduated from college, are earning a steady income and are considering purchasing the condo you are currently renting. You can purchase the condo for $258,000. You have saved $24,000 for the down payment and the bank is willing to loan you $234,000 under a 30-year fixed rate mortgage. The sale will take place at the end of 2020. Payments will be due monthly beginning January 31, 2021.
Required:
- Using Microsoft Excel, develop a spreadsheet to amortize the mortgage loan using the following format and using the following interest rates depending on your last name:
Last name begins with: Use an annual interest rate of:
A-G 4.25%
Loan amount: Annual interest rate:
Number of payments: Monthly interest rate: (use formula & extend to 5 decimal places)
Loan payment start date: Monthly payment: (use PMT function)
Additional Loan
Date Payment Interest Principal Principal Balance
Except for the date (which you should calculate using a fill series) there should be no hard-coded numbers in these fields, only formulas and cell references. Use the $ sign in cell references to keep a column or row from incrementing by one when copying formulas from one row to the next.
- Use the Excel "auto fill" function or cell handle to fill in the date column of your schedule. (Be sure to select “month” as the fill series and start with the second date at your fill point, since the first date is cell referenced).
- Use the Excel "PMT" function to determine the amount of your monthly payment. Show the payment as positive.
- Format all cells except the monthly interest rate to two decimal places (xx.xx)
- Initially set the "additional principal" column to zero
- Calculate totals for the interest, principal and additional principal columns after the row which represents your final payment (and later add temporary totals after the first year of payments to answer several of the questions).
- Any computations necessary to get to an answer should be in cells to the right of the amortization schedule.
2. Use your spreadsheet to answer the following questions. Use formulas to calculate your answers and show your computations in the upper right of your amortization schedule:
- What is the date of your last payment?
- What is the total amount of interest you will pay over the course of the loan?
- What is the total amount of principal you will repay?
- What is the total of the mortgage payments you will make during the first year of the loan?
- How much of these payments will be applied toward the principal amount of the loan?
- A friend of yours who just happens to be an accountant has told you that interest on your home loan is deductible for income tax purposes (and that rent payments are not). After one year, how much interest will you be able to deduct on your income tax return?
- Assume you are in a 20% tax bracket for income tax purposes. What is the average after-tax amount of your monthly mortgage payment in the first year? (HINT: Your interest deduction will be the interest times the tax rate. This is the tax savings which should be deducted from the total of your first year payments. Divide this net amount by 12 to get the monthly average).
- If you were currently renting your condo for $1,100 per month, would it make better sense financially to rent or buy? Why?
- If you are currently renting your condo for $900 per month, why might it still be better financially to buy versus rent?
- Assume that after one year you are earning such a good income that you are able to add an additional $100 to your monthly mortgage payment. Your financial institution will apply this additional payment directly to your outstanding principal balance. Copy your spreadsheet to a new sheet. Beginning January 31, 2022 set the additional principal column of your worksheet to $100 per month. Erase the rows in the worksheet beyond the point that the loan is paid off. Set the final payment (and additional principal amount of the final payment, if necessary) equal to what is necessary to just pay off the loan. Prepare totals for principal, additional principal and the interest columns and answer the following questions.
- How much interest will you save over the course of the loan by paying an additional $100 per month on your mortgage payment?
- How much principal will you pay (think about this logically)?
- By how many years (and/or months) will you reduce your 30-year mortgage by paying an additional $100 per month?
- What is the major lesson of this project?
In: Finance
For a consumer to maximize utility, he will choose the a. point where the slope of...
In: Economics
You have three tickets to a Celtics game on a night that you are going to...
You have three tickets to a Celtics game on a night that you are going to be out of town (so the value of unsold tickets is zero to you). There are only four possible buyers of a Celtics ticket. The table below lists the respective reservation prices of these four possible buyers: Customer Reservation Price 1 $25 2 $35 3 $50 4 $60 How much revenue can you generate if you charge a single price of $25 for the three tickets?
a) How much revenue can you generate if you charge a single price of $35 for the three tickets?
b). How much revenue can you generate if you charge a single price of $50 for the three tickets?
c) How much revenue can you generate if you charge a single price of $60 for the three tickets?
d) Which of the prices fetches you the highest revenue?
e) Next, you think about inviting bids using an English auction to sell your tickets. How much revenue can you generate using the English auction mechanism from the sale of the first ticket?
f) How much revenue can you generate using the English auction mechanism from the sale of the second ticket?
g) How much revenue can you generate using the English auction mechanism from the sale of the third ticket?
h) How much total revenue can you generate using the English auction mechanism?
i) Which pricing strategy gives you higher revenue - English Auction or charging a single price?
In: Economics
Suppose Barefeet is a monopolist that produces and sells Ooh boots, an amazingly trendy brand with no close substitutes.
Suppose Barefeet is a monopolist that produces and sells Ooh boots, an amazingly trendy brand with no close substitutes. The following graph shows the market demand and marginal revenue (MR) curves Barefeet faces, as well as its marginal cost (MC), which is constant at $40 per pair of Ooh boots. For simplicity, assume that fixed costs are equal to zero; this, combined with the fact that Barefeet's marginal cost is constant, means that its marginal cost curve is also equal to the average total cost (ATC) curve.
First, suppose that Barefeet cannot price discriminate. That is, it must charge each consumer the same price for Ooh boots regardless of the consumer's willingness and ability to pay.
On the following graph, use the black point (plus symbol) to indicate the profit-maximizing price and quantity. Next, use the purple points (diamond symbol) to shade the profit, the green points (triangle symbol) to shade the consumer surplus, and the black points (plus symbol) to shade the deadweight loss in this market without price discrimination. (Note: If you decide that consumer surplus, profit, or deadweight loss equals zero, indicate this by leaving that element in its original position on the palette.)
Now, suppose that Barefeet can practice perfect price discrimination-that is, it knows each consumer's willingness to pay for each pair of Ooh boots and is able to charge each consumer that amount.
On the following graph, use the black point (plus symbol) to indicate the profit-maximizing quantity sold and the lowest price at which the firm sells its boots. Next, use the purple points (diamond symbol) to shade the profit, the green points (triangle symbol) to shade the consumer surplus, and the black points (plus symbol) to shade the deadweight loss in this market with perfect price discrimination. (Note: If you decide that consumer surplus, profit, or deadweight loss equals zero, indicate this by leaving that element in its original position on the palette.)
Consider the welfare effects when the industry operates under a monopoly and cannot price discriminate versus when it can price discriminate.
Complete the following table by indicating under which market conditions each of the statements is true. (Note: If the statement isn't true for either single-price monopolies or perfect price discrimination, leave the entire row unchecked.) Check all that apply.
In: Economics
1. Calculating inflation using a simple price index Consider a fictional price index, the College...
1. Calculating inflation using a simple price index
Consider a fictional price index, the College Student Price Index (CSPI), based on a typical college student’s annual purchases. Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2014, 2015, and 2016.
The cost of each item in the basket and the total cost of the basket are shown for 2014.
Perform these same calculations for 2015 and 2016, and enter the results in the following table.
Quantity in Basket | 2014 | 2015 | 2016 | ||||
|---|---|---|---|---|---|---|---|
Price | Cost | Price | Cost | Price | Cost | ||
(Dollars) | (Dollars) | (Dollars) | (Dollars) | (Dollars) | (Dollars) | ||
| Notebooks | 10 | 3 | 30 | 3 | 4 | ||
| Calculators | 1 | 75 | 75 | 80 | 104 | ||
| Large coffees | 300 | 2 | 600 | 2 | 2 | ||
| Energy drinks | 75 | 2 | 150 | 4 | 5 | ||
| Textbooks | 8 | 90 | 720 | 110 | 120 | ||
| Total cost | 1,575 | ||||||
| Price index | 100 | ||||||
Suppose the base year for this price index is 2014.
In the last row of the table, calculate and enter the value of the CSPI for the remaining years.
Between 2014 and 2015, the CSPI increased by
. Between 2015 and 2016, the CSPI increased by _____?
.
Which of the following, if true, would illustrate why price indexes such as the CSPI might overstate inflation in the cost of going to college? Check all that apply.
A new mobile device for personal computing became available for purchase.
Professors required each student to buy eight textbooks, regardless of the price.
Energy drinks became increasingly popular on college campuses between 2014 and 2016 due to significant improvements in flavor, but this quality change is hard to measure.
As the price of calculators rose, fewer students decided to buy them, opting instead to use the free calculators in their cell phones or on their computers.
4. Inflation and interest rates
The following table shows the average nominal interest rates on six-month Treasury bills between 1963 and 1967, which determined the nominal interest rate that the U.S. government paid when it issued debt in those years. The table also shows the inflation rate for the years 1963 to 1967. (All rates are rounded to the nearest tenth of a percent.)
Year | Nominal Interest Rate | Inflation Rate |
|---|---|---|
(Percent) | (Percent) | |
| 1963 | 3.3 | 1.3 |
| 1964 | 3.7 | 1.3 |
| 1965 | 4.1 | 1.6 |
| 1966 | 5.1 | 2.9 |
| 1967 | 4.6 | 3.1 |
Source: “Economic Report of the President (2007),” United States Government Printing Office, last modified February 1, 2007, accessed March 11, 2013, http://www.gpo.gov/fdsys/pkg/ERP-2007/pdf/ERP-2007.pdf.
On the following graph, use the orange points (square symbol) to plot the nominal interest rates for the years 1963 to 1967. Next, use the green points (triangle symbol) to plot the real interest rates for those years.
According to the table, in which year did buyers of six-month Treasury bills receive the highest real return on their investment?
1963
1964
1965
1966
1967
In: Economics
The price of a non-dividend-paying stock is $45. The strike price of a six-month American put...
The price of a non-dividend-paying stock is $45. The strike price of a six-month American put option is $50. The risk-free rate is 3% (continuously compounded). Which of the following is a lower bound for the option such that there are arbitrage opportunities if the price is below the lower bound and no arbitrage opportunities if it is above the lower bound?
In: Finance
Consider the following information on the stock market. Company Shares Outstanding Price, beginning of year Price,...
Consider the following information on the stock market.
|
Company |
Shares Outstanding |
Price, beginning of year |
Price, end of year |
|
A |
200 |
$58 |
$94 |
|
B |
500 |
$20 |
$25 |
|
C |
1000 |
$70 |
$6 |
- Compute a price-weighted stock price index for the beginning of the year and the end of the year. What is the percentage change?
- Compute a value-weighted stock price index for the beginning of the year and the end of the year. What is the percentage change?
In: Finance