Question
In: Economics
Use Excel to answer the following question: Sundance Detective Agency purchased new surveillance equipment with the...
Use Excel to answer the following question:
Sundance Detective Agency purchased new surveillance equipment with
the following estimates. Note: The year index is k = 1, 2, 3, ...
to calculate the maintenance costs and extra revenues for the
corresponding years.
| First cost ($) | 1,050 |
| Annual maintenance cost ($ in year k) | 70 + 5k |
| Extra revenue ($ in year k) | 200 + 50k |
| Salvage value ($ at the end of the useful life) | 600 |
(a) Prepare a cash-flow (CF) table, do present worth (PW) analysis
using an appropriate Excel built-in function to calculate the
discounted payback period x with a return of 10% per year.
(b) For a preliminary conclusion, should the equipment be purchased
if the actual useful life is 7 years? Comment.
Solutions
Rahul Sunny answered 8 months agoRelated Solutions
Plot the following parabolic functions in Excel and then answer the discussion question below . Use...
Plot the following parabolic functions in Excel and then answer
the discussion question below . Use at least 8 points for each
plot: Each graph is worth 15 points and must include 8 points. 1)
y=x2-6x+8 2) y=x2+4 3) y=(-1/2)(x2) 4) What is the maximum number
and the minimum number of x-intercepts for a parabola? Why? (15
points) In order to obtain full credit, you will need to plot the
functions in Excel or using the Open Office feature and...
Use Excel to answer the following question: The capital fund for research project investment at a...
Use Excel to answer the following question:
The capital fund for research project investment at a
corporation is limited to $100,000 for next year. The company uses
an MARR of 15% per year. There are three independent project
proposals (i.e., none, one or more can be selected) with pertinent
information given in the below table.
Project
Initial Investment ($)
Annual Net Cash Flow ($/year)
Life (years)
Salvage Value ($)
A
-25,000
6,000
4
4,000
B
-30,000
9,000
4
-1,000
C...
Please solve handwritten, no Excel. A company purchased new casting equipment at a cost of $250,000....
Please solve handwritten, no Excel.
A company purchased new casting equipment at a cost of $250,000.
The company also paid an extra $70,000 in necessary costs to have
the equipment delivered and installed. The casting machine has an
estimated service life of 10 years, and it will be depreciated at a
CCA rate = 25%.
a] What is the Cost Basis of the casting equipment?
b] What will be the CCA amount each year for the service life of
the...
Conduct an analysis (you can use Excel) to answer the following question. Show an ANOVA table....
Conduct an analysis (you can use Excel) to answer the following
question. Show an ANOVA table.
A grower wishes to compare yields of four different varieties of
pumpkins for yield (tons/ac). His experiment consisted
of four replications for each variety. Is there a
significant difference between the varieties in
yield? Do a Tukey’s test. Give complete conclusions with
a properly labeled tabulated results. Data are as follows:
Variety A Variety
B Variety
C Variety D
27 29 30 32
28 28 29 29
29 29 29 31
25 27 31 32
An experiment was conducted to compare the...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are...
Excel Assignment 2
Direction: Use Microsoft Excel to answer the following three
questions (Excel Instructions are provided in previous
assignment)
1. An Economist was interested in sex differences in the number of
books a person reads (see file: Number of Books). Two random
samples were taken, one of men and the other, and the number of
books read during the last month was recorded. Is there a
difference with respect to the number of books read by females and
males?...
use excel and show formulas A piece of equipment will cost $325,000 new, have a six...
use excel and show formulas A piece of
equipment will cost $325,000 new, have a six year life and a
salvage value of $100,000. Maintenance costs are $30,000 for year 1
and increase at the rate of 6% per year. Determine the annual cost
of this machine if i=12%
Use it and Excel to answer this question. It contains Assignment 1 marks for two past...
Use it and Excel to answer this question. It contains Assignment
1 marks for two past sections of this course
Treat it as a random sample. Perform a hypothesis test to
determine if the two sample means are equal. Use α = 0.10.
Section A
Section B
15
16
26
52
52
55
53
57.5
54
58
56.5
60
61
61
61.5
70
63
70
66
71
66
72
66.5
73
69
74.5
71
75
77
75.5
77
76
78...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the
United States Census Bureau’s estimates for World Population from
1950 to 2014. You will find a column of dates and a column of data
on the World Population for these years. Generate the time variable
t. Then run a regression with the Population data as a dependent
variable and time as the dependent variable. Have Excel report the
residuals.
(a) Based on the ANOVA table and t-statistics, does...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the
United States Census Bureau’s estimates for World Population from
1950 to 2014. You will find a column of dates and a column of data
on the World Population for these years. Generate the time variable
t. Then run a regression with the Population data as a dependent
variable and time as the dependent variable. Have Excel report the
residuals.
(a) Based on the ANOVA table and t-statistics, does...
Use the following information to answer the question(s) below. Kester Co. purchases a piece of equipment...
Use the following information to answer the question(s)
below.
Kester Co. purchases a piece of equipment on May 1, 20xx, for
$30,000. The equipment has an estimated life of eight years or
50,000 units of production and an estimated residual value of
$3,000. Kester uses a calendar fiscal year.
----------
What is the amount of straight-line depreciation to be recorded
in the first partial year? (Hint: use the nearest month and
calculate a partial year.)
Question 20 options:
1)
$3,750...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
- There are a large number of tasks involved in information technology and programming, and many of...
ADVERTISEMENT