In: Statistics and Probability
On February 1, 2016, Baker Company issued 9% bonds, dated February 1, with a face amount of $ 80 million. The bonds mature on January 31, 2020 ( 4 years). The market yield for bonds of similar risk and maturity was 10%. Interest is paid semiannually on July 31 and January 31. The Fiscal years of both firms end December 31
Crimley Motor Products
Bond Issue: $80,000,000
Bond Issue years: 4 years
Bond Issue interest rate: 9%
Market Annual Yield: 10%
Using excel functions prepare amortization schedules that the effective interest expense on the bond
| Amortization Schedule | ||||
| Cash | Effective | |||
| Payment | Interest | Increase in | Outstanding | |
| 4.5% | 5% | Balance | Balance | |
| 77,414,714.90 | ||||
| 1 | 3,600,000 | |||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8* | - | - | - | |
| *rounded | ||||
Using my calculator I can get the below information and the schedule done, but I need to do with the excel functions
i/y=10/2 = 0.05
N=4*2 = 8
pmt = 3,600,000
FV = 80,000,000
PV= 77,414,714.90
In: Accounting
A calculation engine is being built to set up an order-of-operations for solving equations. The priority of the operations is as follows:
1. Parentheses, Priority 1 highest
2. Exponents, Priority 2
3. Multiplication, Priority 3
4. Division, also Priority 3
5. Modulus, also Priority 3
6. Addition, Priority 4, Lowest
7. Subtraction, Also priority 4
Each of bulleted items in the list above is represented by a one-bit input wire in a control circuit system, for a total of 7 inputs. The outputs are binary integers 1 through 4.
Use combinational logic and gate logic to create a piece of control circuitry that will assign the correct 2-bit binary integer based on the system priority. The output should be the highest priority among the inputs.
Include a short, well-written description about the approach you chose. Do not include a 128-line truth table. If you use this approach, you are going about it the wrong way. Remember: Divide and Conquer!
the final set of outputs on question 4.4 would be in the form of {001,010,011,100}.
In: Computer Science
Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires $225,000 of equipment. She is unsure what depreciation method to use in her analysis, straight-line or the 3-year MACRS accelerated method. Under straight-line depreciation, the cost of the equipment would be depreciated evenly over its 4-year life (ignore the half-year convention for the straight-line method). The applicable MACRS depreciation rates are 33%, 45%, 15%, and 7%. The company's WACC is 11%, and its tax rate is 35%.
What would the depreciation expense be each year under each method? Round your answers to the nearest cent.
Scenario 1 (Straight-Line)
Year 1
Year 2
Year 3
Year 4
Scenario 2 (MACRS)
Year 1
Year 2
Year 3
Year 4
Which depreciation method would produce the higher NPV?
How much higher would the NPV be under the preferred method? Round your answer to two decimal places. Do not round your intermediate calculations.
In: Finance
Solo limited makes and sells a single product .The following data relates to period 1 to 4.
Variable cost per unit 30
Selling price per unit 55
Fixed cost per period 6000
Normal activity is 500 units and production and sales for the four periods are as follows;
Periods 1 2 3 4
Sales 500 400 550 450
Production 500 500 450 500
Prepare operating statements for each of the periods 1 to 4 based on marginal costing principles.
Prepare operating statements for each of the periods 1 to 4 based on absorption costing principles.
Comment briefly on the results obtained in each period and in total by the two systems.
In: Accounting
1.A report in a research journal states that the average weight loss of people on a certain drug is 23 lbs with a margin of error of ±2 lbs with confidence level C = 95%.
(a) According to this information, the mean weight loss of people on this drug, μ, could be as low as .........lbs.
(b) If the study is repeated, how large should the sample size be so that the margin of error would be less than 1 lbs? (Assume σ= 10 lbs.)
2.Suppose the number of cars in a household has a
binomial distribution with parameters n=14n=14 and
p=10p=10%.
Find the probability of a household having:
(a) 9 or 12 cars
(b) 10 or fewer cars
(c) 10 or more cars
(d) fewer than 12 cars
(e) more than 10 cars
3.Find the probability of throwing a sum of 11 at least 9 times
in 12 throws
of a pair of fair dice.
4. If XX is a binomial random variable, compute P(X=x)P(X=x) for each of the following cases:
(a) n=6,x=3,p=0.6n=6,x=3,p=0.6
P(X=x)=P(X=x)=
(b) n=4,x=2,p=0.6n=4,x=2,p=0.6
P(X=x)=P(X=x)=
(c) n=4,x=2,p=0.8n=4,x=2,p=0.8
P(X=x)=P(X=x)=
(d) n=4,x=2,p=0.4n=4,x=2,p=0.4
P(X=x)=
5.A report in a research journal states that the average weight loss of people on a certain drug is 2323 lbs with a margin of error of ±2±2 lbs with confidence level C = 95%.
(a) According to this information, the mean weight loss of people on this drug, μμ, could be as low as ........ lbs.
(b) If the study is repeated, how large should the sample size be so that the margin of error would be less than 1 lbs? (Assume σ= 10σ= 10 lbs.)
In: Statistics and Probability
Do It! Review 11-3b Oriole Company has had 4 years of record earnings. Due to this success, the market price of its 435,000 shares of $4 par value common stock has increased from $15 per share to $52. During this period, paid-in capital remained the same at $5,220,000. Retained earnings increased from $3,915,000 to $26,100,000. CEO Don Ames is considering either (1) a 15% stock dividend or (2) a 2-for-1 stock split. He asks you to show the before-and-after effects of each option on (a) retained earnings, (b) total stockholders’ equity, and (c) par value per share. (a) 1. Stock dividend - retained earnings $ 2. 2-for-1 stock split - retained earnings $ (b) Oriole Company Original Balance After Dividend After Split Paid-in capital $ $ $ Retained earnings Total stockholder’s equity $ $ $ Shares outstanding (c) 1. Stock dividend - par value per share $ 2. 2-for-1 stock split - par value per share $ Click if you would like to Show Work for this question: Open Show Work
In: Accounting
Texas Instrument is considering a potential project. It requires an initial investment of $10 mil and is expected to last 4 years. Revenues and costs at the end of the first year are expected to be $6 mil and $2 mil, respectively. Both are expected to stay constant for the life of the project. The firm uses straight line depreciation and has 0 remaining value at the end. The working capital levels in years 1 to 4 are: $0.5 mil, $1 mil, $1.5 mil, and 0, respectively. Assume a tax rate of 35%. Calculate the free cash flow to firm (FCFF) in each of the 4 years (year 1 to year 4).
In: Finance
Create the generating functions in closed form ( not as an infinite sum) using the sequences:
example: 1,1,1,1,1,1,... = 1/(1-x)
1. 0,1,1,1,1,1,...
2. 1,0,0,1,0,0,1,0,0,1,0,0,1,...
3. 0, 0,0,0,1,1,1,1,1,1,1,1,1,...
4. 1, -1, 1, -1, 1,....
5. 1,1,1,0,0,1,1,1,1,1,1,1,1,1,...
6. 0,0,0,1,2,3,4,5,6,..
7. 3,2,4,1,1,1,1,1,...
8. 0,2,0,0,2,0,0,2,0,0,..
In: Advanced Math
Danube recently acquired a delivery van for $24,200 paying cash. Danube projects a 4 year useful service life and a remaining residual value on the delivery van of $2,200. Danube expects to drive the van 106,000 miles during the useful service life. Please compute the annual depreciation for the 4 year life of the delivery van for each of these methods:
1. Straight-line
Depreciation expense
2. Double-declining-balance. (Round your depreciation rate to 2 decimal places. Round your final answers to the nearest whole dollar.) End year ammounts. Years 1,2,3, with depreciation expense, accumulated depreciation and book value for each year.
3. Actual miles driven each year were 19,000 miles in Year 1; 29,000 miles in Year 2; 23,000 miles in Year 3; and 25,000 miles in Year 4. Note that actual total miles of 96,000 fall short of expectations by 10,000 miles. Calculate annual depreciation for the four-year life of the van using activity-based. (Round your depreciation rate to 2 decimal places.) end of year amounts year 1, 2, 3, 4, with depreciation expense, accumulated depreciation and book value for each year.
In: Accounting