2. Let x be the number of years after 2007 and y represent the number of students enrolled at WWCC. Answer the following given the data that enrollment was 2055 in the year 2007, 2244 in 2008, 2512 in 2009, 2715 in 2010, and 2765 in 2011.
(a) Find the least-squares line for the data using Excel and submit your file in Canvas.
(b) Using partial derivatives, verify the formula you obtained in Excel.
(c) Find the least-squares error E
In: Statistics and Probability
QUESTION 13
SECTION 1
Because deflation is so costly, some have argued that setting an
inflation target at 2 percent is too low and it should be set
higher, to 3 percent, especially in the economic environment of
2007–2010.
In: Economics
I have figured out the risk premium and average risk premium for the question below. I'm having trouble figuring out what the standard deviation of the risk premium is. 2006 18.67 7.50 2007 9.01 7.16 2008 −39.83 2.80 2009 30.90 0.80 2010 20.56 0.92 The average risk premium is 4.03% but can't figure out how to calculate standard deviation of the risk premium.
Yes, an excel function will do.
Thank you.
In: Finance
1. The first bitcoin transaction was conducted on January 12th 2009. In its early days, the value of bitcoins were practically zero (In March 2010, a user auctioned 10,000 bitcoins for a total of $50 but no buyer was found.) By December 17th, 2017, the price of bitcoin has reached an all-time high of $19,783. As of today (March 12, 2019), its price is $3,858.
a. In what ways is bitcoin similar to a Ponzi scheme?
b. In what ways is bitcoin different?
In: Economics
Using the Vehicle Ratings Excel file, create formulas using nested IF, AND, and OR functions to implement the three rating schemes described on the spreadsheet.
| Rating 1 | ||||||||||||||||
| If the vehicle has A/C and a sunroof or it is newer than 2013, then YES, otherwise NO. | ||||||||||||||||
| Rating 2 | ||||||||||||||||
| If the vehicle is Red and does not have high miles, then YES, otherwise if it is a Ford or Chevy, MAYBE, otherwise NO. | ||||||||||||||||
| Rating 3 | ||||||||||||||||
| If the vehicle is older than 2013 and is priced under $15,000 or it is a Honda with a sunroof, then YES, otherwise, if the vehicle is a black Accord or black Corolla, then MAYBE, otherwise NO. |
| Make | Model | Year | Color | A/C | Sunroof | Mileage | High Miles | Price | Rating 1 | Rating 2 | Rating 3 |
| Toyota | Corolla | 2009 | Silver | No | Yes | 73,497 | No | $10,497 | |||
| Chevrolet | Malibu | 2012 | Blue | No | Yes | 84,690 | No | $11,489 | |||
| Ford | Fusion | 2014 | Black | Yes | No | 109,308 | Yes | $11,815 | |||
| Honda | Accord | 2013 | Red | No | No | 85,353 | No | $12,493 | |||
| Ford | Focus | 2014 | Black | Yes | No | 103,742 | Yes | $12,507 | |||
| Toyota | Corolla | 2014 | Black | No | Yes | 109,295 | Yes | $12,593 | |||
| Honda | Civic | 2012 | White | Yes | Yes | 119,522 | Yes | $13,333 | |||
| Chevrolet | Impala | 2013 | Blue | Yes | No | 108,226 | Yes | $13,630 | |||
| Chevrolet | Impala | 2009 | Blue | Yes | Yes | 111,691 | Yes | $13,980 | |||
| Ford | Focus | 2012 | Black | No | Yes | 75,772 | No | $14,251 | |||
| Honda | Accord | 2012 | Silver | Yes | No | 75,220 | No | $14,258 | |||
| Chevrolet | Malibu | 2012 | Blue | No | No | 81,587 | No | $15,246 | |||
| Ford | Fusion | 2010 | Red | No | Yes | 79,049 | No | $15,790 | |||
| Honda | Civic | 2009 | Blue | Yes | No | 88,548 | No | $16,036 | |||
| Toyota | Camry | 2013 | Silver | Yes | Yes | 115,050 | Yes | $16,344 | |||
| Honda | Accord | 2013 | Silver | No | No | 77,072 | No | $16,355 | |||
| Chevrolet | Malibu | 2011 | Blue | No | Yes | 82,792 | No | $16,556 | |||
| Toyota | Camry | 2010 | Red | Yes | Yes | 88,163 | No | $17,248 | |||
| Chevrolet | Silverado | 2009 | White | No | No | 100,179 | Yes | $17,964 | |||
| Toyota | Corolla | 2013 | Blue | Yes | Yes | 117,039 | Yes | $17,965 | |||
| Honda | Civic | 2012 | Red | Yes | No | 73,533 | No | $19,722 | |||
| Honda | Civic | 2011 | White | Yes | No | 88,786 | No | $19,864 | |||
| Chevrolet | Impala | 2011 | Silver | Yes | Yes | 77,060 | No | $20,339 | |||
| Ford | F-150 | 2014 | Red | Yes | No | 105,489 | Yes | $20,380 | |||
| Ford | Fusion | 2013 | Silver | No | No | 109,223 | Yes | $20,532 | |||
| Ford | F-150 | 2012 | Red | No | No | 76,025 | No | $20,659 | |||
| Honda | Accord | 2010 | Blue | Yes | No | 76,701 | No | $21,138 | |||
| Chevrolet | Silverado | 2014 | Silver | Yes | No | 72,319 | No | $21,148 | |||
| Chevrolet | Malibu | 2013 | White | No | No | 117,518 | Yes | $21,183 | |||
| Chevrolet | Silverado | 2009 | Black | No | Yes | 101,839 | Yes | $21,226 | |||
| Chevrolet | Malibu | 2014 | Blue | Yes | No | 80,179 | No | $21,466 | |||
| Toyota | Camry | 2010 | Blue | No | Yes | 74,937 | No | $21,976 | |||
| Ford | F-150 | 2011 | Black | Yes | Yes | 117,249 | Yes | $22,883 | |||
| Ford | Focus | 2014 | Silver | Yes | No | 77,527 | No | $23,235 | |||
| Ford | Fusion | 2011 | White | Yes | Yes | 81,907 | No | $23,835 |
In: Finance
Total Solution Ltd. is rendering its service on Network Solution to two types of customers: Company and Household. It categorised its operating department into: Company-Service and Household Service. Total Solution Ltd. also has two support departments: Administration (Admin) and Technician (Tech). Each of the operating departments conducts its operations independently. Total Solution Ltd. uses the number of technician’s hours used to allocate Tech costs and the number of admin staff used to allocate Admin costs. The following data are available for May 2020. Support Departments Operating Departments Admin Tech Company Household Budgeted costs $1,355,000 $3,200,000 $5,000,000 $4,000,000 Budgeted processing time (in min) 1,000 --- 1,600 2,400 Number of employees --- 15 9 36 Required (show your workings): Allocate the cost from support department to operating department and determine the total budgeted cost of each operating department after the cost has been allocated from the support department using the following method:
(a) Direct method
(b) Step-down method if the support department with highest dollar amount is allocated first. (c) Reciprocal method (using linear equation)
In: Accounting
Suppose you are considering purchasing RadRover 5, the electric fat bike of the year 2020, that retails at a price of $1600. The bike dealer offers you the following financing scheme. Pay $600 as down payment today and finance the remainder $1000 from the dealer at 200% EAR, with daily compounding. You are required to repay the amount financed in 30 equal daily payments starting tomorrow. The scheme also comes with an option to “extinguish” the loan anytime during the next month by repaying the outstanding balance at the start of a day in one lump sum payment.
A) What is the daily payment amount that you will have to pay to the dealer?
B) Your elder brother has agreed to help you extinguish the loan if you can demonstrate to him that you can make regular loan payments for at least 4 consecutive days. How much will it cost your brother to extinguish the loan at the start of day 5 if you have already made first of your 4 daily payments.
C) How much profit (at the end of next month) would the dealer make over and above the $1600 retail price if you made all the promised payments?
In: Accounting
Bramble Corporation operates a retail computer store. To improve delivery services to customers, the company purchases four new trucks on April 1, 2020. The terms of acquisition for each truck are described below.
| 1. | Truck #1 has a list price of $42,150 and is acquired for a cash payment of $39,059. | |
| 2. | Truck #2 has a list price of $44,960 and is acquired for a down payment of $5,620 cash and a zero-interest-bearing note with a face amount of $39,340. The note is due April 1, 2021. Bramble would normally have to pay interest at a rate of 10% for such a borrowing, and the dealership has an incremental borrowing rate of 8%. | |
| 3. | Truck #3 has a list price of $44,960. It is acquired in exchange for a computer system that Bramble carries in inventory. The computer system cost $33,720 and is normally sold by Bramble for $42,712. Bramble uses a perpetual inventory system. | |
| 4. | Truck #4 has a list price of $39,340. It is acquired in exchange for 900 shares of common stock in Bramble Corporation. The stock has a par value per share of $10 and a market price of $13 per share. |
Prepare the appropriate journal entries for the above transactions for Bramble Corporation.
thanks!
In: Accounting

Exercise 16-23
On June 1, 2018, Andre Company and Agassi Company merged to form Lancaster Inc. A total of 800,000 shares were issued to complete the merger. The new corporation reports on a calendar-year basis.
On April 1, 2020, the company issued an additional 400,000 shares of stock for cash. All 1,200,000 shares were outstanding on December 31, 2020.
Lancaster Inc. also issued $600,000 of 20-year, 8% convertible bonds at par on July 1, 2020. Each $1,000 bond converts to 40 shares of common at any interest date. None of the bonds have been converted to date.
Lancaster Inc. is preparing its annual report for the fiscal year ending December 31, 2020. The annual report will show earnings per share figures based upon a reported after-tax net income of $1,540,000. (The tax rate is 20%.)
Determine the following for 2020.
(a) The number of shares to be used for calculating: (Round answers to 0 decimal places, e.g. $2,500.) shares
(1) Basic earnings per share
(2) Diluted earnings per share shares
(b) The earnings figures to be used for calculating: (Round answers to O decimal places, e.g. $2,500.)
(1) Basic earnings per share t
(2) Diluted earnings per share &
In: Accounting
The trial balance of Scan House, Inc. included the following
selected accounts as of December 31, 2020: Debits Credits Sales
Revenue 16,755,000
Interest Revenue 75,000 Gain on sale of investments 150,000
Unrealized gains on investments 200,000 Other Income * 1,200,000
Foreign currency translation losses 125,000 Cost of Goods Sold
11,635,000
Selling expenses 975,000 Goodwill impairment loss 550,000 Interest
Expense 60,000 Administrative Expense** 780,000 Loss on sale of
land 225,000 Dividends declared 175,000
Additional information:
* Other Income consists of income from discontinued operations.
This includes $900,000 of income from operations and a $300,000
gain on the sale of investments.
** Administrative expense includes a $150,000 expense that was a
correction of an error made in the 2018 Income Statement, but
discovered during 2020.
Retained Earnings balance: January 1, 2020 = $725,000.
ScanHouse had 600,000 shares of common stock outstanding throughout
the year and 1,000,000 shares of common stock authorized. Income
tax expense had not yet been accrued. The effective tax rate is
21%.
Required: 1. Prepare a single, continuous 2020 statement of
comprehensive income for Scan House, Inc., including income tax
expense and Earnings Per Share (EPS). Use a multiple-step
income
2. Prepare a 2020 statement of retained earnings for Scan House, Inc.
In: Finance