Question
In: Finance
*****PLEASE SHOW IN EXCEL***** 4. An industrial grade lazer printer with the retail price is offered...
*****PLEASE SHOW IN EXCEL*****
| 4. An industrial grade lazer printer with the retail price is offered for $3,900. If the sale is for 36 months with $135 per monthly payments, what is the interest rate? |
| A. 14.15 percent |
| B. 14.90 percent |
| C. 15.60 percent |
| D. 18.75 percent |
| E. 19.15 percent |
Solutions
jeff jeffy answered 10 months agoRelated Solutions
Please use excel and demonstrate the formulae used. A medium-sized industrial grade compressor can be purchased...
Please use excel and demonstrate the formulae used.
A medium-sized industrial grade compressor can be purchased for
$35,000. Annual O&M costs are expected to increase $1,300 every
year, with a 1st year O&M cost of $2,000. (MARR = 16%, and
planning horizon is 10 years)
The compressor salvage value for a given period
t, is calculated based on the following
equation: Salvage value (t) = $30,000– $3,000 * t
a) Find the Optimum Replacement Interval for this Equipment
b) Find...
SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score...
SHOW STEPS IN EXCEL PLEASE
Consider the following data on price ($) and the overall score
for six stereo headphones tested by a certain magazine. The overall
score is based on sound quality and effectiveness of ambient noise
reduction. Scores range from 0 (lowest) to 100 (highest).
Brand
Price ($)
Score
A
180
76
B
150
71
C
95
61
D
70
58
E
70
40
F
35
24
(a)
The estimated regression equation for this data is
ŷ =...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!!
SHOW CALCULATIONS / FORMULAS IN
EXCEL!!!!!!!!
Voters arrive at a polling station at an average of 4 per minute
(Poisson) where the service rate is 50 per hour (Poisson).
a. What is the average number of voters in the system with 5
voter booths? (10 pts)
b. What is the minimum number of voting booths needed to keep
the average time in the system under three minutes? (10 pts)
PLEASE SHOW ALL WORK IN...
PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK YOU! XYZ stock price and...
PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK
YOU!
XYZ stock price and dividend history are as follows:
Year
Beginning-of-Year Price
Dividend Paid at Year-End
2015
$
106
$
5
2016
101
5
2017
89
5
2018
94
5
An investor buys three shares of XYZ at the beginning of 2015,
buys another two shares at the beginning of 2016, sells one share
at the beginning of 2017, and sells all four remaining shares at
the beginning...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT
ARE USED********
A company is considering the purchase of a new machine that will
enable it to increase its expected sales. The machine will have a
price of $100,000. In addition, the machine must be
installed and tested. The costs of installation and
testing will amount to $10,000. The machine will be
depreciated using 3-years MACRS. (Use MACRS table from class excel
exercise by copying the table and pasting it)
The
equipment will...
Questions 1-4 show excel formulas The coupon rate and market price for the 10-year US Treasury...
Questions 1-4 show excel formulas
The coupon rate and market price for the 10-year US Treasury
bond are 2.50% and 96.3828 respectively. Note, the price is
expressed as a percentage of par (like other bonds). If par is
$1000, then this bond is selling for $963.828.
1. Assume that this bond will mature in precisely 10 years, pay
coupons semi-annually, and has a par value of $1000. Determine the
yield to maturity for this bond.
2. Compute the duration of...
Please show excel farmulas Homework One Line 18 Lower price for cup to 1.40 Homework Two...
Please show excel farmulas
Homework
One Line 18 Lower price for cup to 1.40
Homework Two Line
34 Higher Fixed but lower Variable
Conrads Coffee
(Page 266 Chapter 13)
Class Example
F+G
E/A
Chg in E
B-E
C-I
Quantity
Total Rev ($1.50 a cup)
Marginal Revenue
Total cost
Fixed Cost
Var Cost
Avg Total costs
Marginal costs
Profit
MR-MC
$ 3.00
3.00
$ (3.00)
1
$ 1.50
1.50
$ 3.30
3.00
0.30
3.30
0.30...
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and
show all formulas used in each cell I would really appreciate the
work***
Three-Stage FCFE Model:
Biomet Inc., designs, manufactures and markets reconstructive
and trauma devices, and reported earnings per share of $0.56 in
1993, on which it paid no dividends. (It had revenues per share in
1993 of $2.91). It had capital expenditures of $0.13 per share in
1993 and depreciation in the same year of $0.08 per...
Please answer in excel only. How do I create the graphs in excel and show the...
Please answer in excel only. How do I create the graphs in excel
and show the data.
Discuss the following two cost functions:
TC=20+4Q
TC=20+2Q+0.5Q^2
a) Calculate all cost curves and plot these curves on
graphs.
Total Cost
Total Fixed Cost
Total Variable Cost
Average Total Cost
Average Fixed Cost
Average Variable Cost
Marginal Cost
b) In each case, indicate the point at which diminishing returns
occur.
(For question a), compute the required costs and plot the curves
for quantities...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet,
Thank you so much!
The following are the runs scored totals for 9 players for the
2016 New York Yankees: 56,43,63,68,58,80,71,32,19
(a) Find the mean and median
(b) Find the standard deviation of this population
(c) Considering this as a normal sample of American League
players for the 2016 season, find a 99% Confidence Interval for the
actual mean of Runs Scored for AL players, 2016 .
(d) Considering...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- anson, Mahoney, and Longval, a parmership, is considering admitting Kellan Young as a new parmer. On...
- Given the following solubilities in grams/100ml of water (these are the amounts that stay in solution...
- A portfolio to the right of the market portfolio on the CML is ___________. a lending...
- Mini case study – Scottish Parliament: the £431m question Scotland’s new parliament building cost more than...
- If you start with 3.0×10^10 I−131 atoms, how many are left after approximately 1month? I−131 has...
- An unidentified covalent molecular compound contains only carbon, hydrogen, and oxygen. When 7.40 mg of this...
- Discuss the risk-benefit analysis, please provide examples of its application.
ADVERTISEMENT