Your research team has been tasked with finding the correlation of the following scenario:
Four research participants take a test of manual dexterity (high scores mean better dexterity) and an anxiety test (high scores mean more anxiety). The scores are as follows:
Person Dexterity Anxiety
1 1 10
2 1 8
3 2 4
4 4 -2
Describe the process your research team would go through by completing the following:
In: Statistics and Probability
A machine can be purchased for $226,000 and used for five years,
yielding the following net incomes. In projecting net incomes,
double-declining depreciation is applied using a five-year life and
a zero salvage value.
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||
| Net income | $ | 22,500 | $ | 44,000 | $ | 77,000 | $ | 46,000 | $ | 108,000 | ||||||||||
Compute the machine’s payback period (ignore taxes). (Round
payback period answer to 3 decimal places.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
A firm is considering an investment project with the following cash flows: Year 0 = -$110,000 (initial costs); Year 1= $40,000; Year 2 =$90,000; and Year 3 = $30,000; and Year 4 = $60,000. The company has a 10% cost of capital. What is the project’s discounted payback?
|
1.67 years |
||
|
1.86 years |
||
|
1.99 years |
||
|
2.08 years |
A firm is considering an investment project with the following cash flows: Year 0 = -$110,000 (initial costs); Year 1= $40,000; Year 2 =$90,000; and Year 3 = $30,000; and Year 4 = $60,000. The company has a 10% cost of capital, calculate the NPV for the project.
|
$58,569 |
||
|
$64,264 |
||
|
$74,264 |
||
|
$77,333 |
A firm is considering an investment project with the following cash flows: Year 0 = -$110,000 (initial costs); Year 1= $40,000; Year 2 =$90,000; and Year 3 = $30,000; and Year 4 = $60,000. The company has a 10% cost of capital, calculate the IRR for the project.
25.9%
29.8%
34.6%
40.7%
In: Finance
3. The IRR is the rate which makes the principal at the beginning of the year following the last cash flow is paid out equal to 0. This is shown in the table below. Use the Goal Seek function of Excel to find this rate.
|
A |
B |
C |
D |
E |
F |
G |
H |
||
|
1 |
IRR? |
3.00% |
|||||||
|
2 |
LOAN TABLE |
||||||||
|
3 |
Year |
Cash flow |
Year |
Principal at beginning of year |
Payment at end of year |
Interest |
Principal |
||
|
4 |
0 |
-800 |
1 |
800.00 |
300.00 |
24.00 |
276.00 |
||
|
5 |
1 |
300 |
2 |
524.00 |
200.00 |
15.72 |
184.28 |
||
|
6 |
2 |
200 |
3 |
339.72 |
150.00 |
10.19 |
139.81 |
||
|
7 |
3 |
150 |
4 |
199.91 |
122.00 |
6.00 |
116.00 |
||
|
8 |
4 |
122 |
5 |
83.91 |
133.00 |
2.52 |
130.48 |
||
|
9 |
5 |
133 |
6 |
-46.57 |
ß Should be zero for IRR |
||||
Check the value that you get and compare it to the Excel IRR function.
Help me with this please. In Excel using goal seek.
In: Finance
A machine can be purchased for $222,000 and used for five years,
yielding the following net incomes. In projecting net incomes,
double-declining depreciation is applied using a five-year life and
a zero salvage value.
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||
| Net income | $ | 19,000 | $ | 49,000 | $ | 59,000 | $ | 57,500 | $ | 105,000 | ||||||||||
Compute the machine’s payback period (ignore taxes). (Round
payback period answer to 3 decimal places.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
3.3) A small market orders copies of a certain magazine for its magazine rack each week. Let X = demand for the magazine, with the following pmf.
| x | 1 | 2 | 3 | 4 | 5 | 6 | ||||||||||||
| p(x) |
|
|
|
|
|
|
Suppose the store owner actually pays $2.00 for each copy of the magazine and the price to customers is $4.00. If magazines left at the end of the week have no salvage value, is it better to order three or four copies of the magazine? [Hint: For both three and four copies ordered, express net revenue as a function of demand X, and then compute the expected revenue.]
*What is the expected profit if three magazines are ordered? (Round your answer to two decimal places.)
*What is the expected profit if four magazines are ordered? (Round your answer to two decimal places.)
*How many magazines should the store owner order?
-3 magazines
-4 magazines
In: Math
Q1
a)
Given the following cashflows for Project Omega, what is the payback period in years assuming the cashflows occur annually?
| Year | Cashflows of Project Omega |
| 0 | -90,000 |
| 1 | 20,000 |
| 2 | 25,000 |
| 3 | 50,000 |
| 4 | 40,000 |
| 5 | 150,000 |
b)
Project X and Y. The following are the cash flows of two projects:
| Year | Project X | Project Y |
| 0 | -100,000 | -50,000 |
| 1 | 50,000 | 20,000 |
| 2 | 40,000 | 30,000 |
| 3 | 30,000 | 30,000 |
| 4 | 20,000 | |
| 5 | 10,000 |
If the discount rate is 18% is the project with the highest profitability index also the one with the highest NPV?
Yes
No
c)
he cashflows for an investment in Factory X are listed below. Using the discounted payback method of capital budgeting, what is the payback period for this investment expressed in years, assuming that the cashflows occur annually and using a discount rate of 20%.
| Year | Factory X |
| 0 | - 300,000 |
| 1 | 50,000 |
| 2 | 50,000 |
| 3 | 100,000 |
| 4 | 100,000 |
| 5 | 200,000 |
| 6 | 200,000 |
In: Finance
Assume that you have the following possible cash flows:
Years 1 and 2 CFs = $300;
Year 3 CF = $100;
Years 4 and 5 CFs = $200.
What is the value of the cash flows at year 4 if the required discount rate is 5%?
In: Finance
Write an ESSAY on what you understand about:
1. Anti- Ice and De-ice
2. Type of Ice
3. Type of ice accretion detectors
4. Areas need for protections
5. 4 principle of Anti-ice
6. Rain protection.
In: Mechanical Engineering
You are interested in purchasing an apartment complex for $2,000,000 that has Net Operating Income (NOI) of $120,000 and is financed with an 80% LTV mortgage at 4%
1. What is the Cap Rate?
2. What is the ROA?
3. What is the leverage ratio?
4. Approximate the ROE
In: Finance