1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
aksik [14]
1 year ago
13

5. Use excel?s irr function for this problem. Rancho cucamonga has a 6% cost of capital. The firm has an investment opportunity

that costs $2,000. Riverside expects the investment to generate annual cash inflows $600 for each of the next four years. The internal rate of return and rancho?s decision are a. 1. 7% and invest in the project. B. 1. 7% and don?t invest in the project. C. 7. 7% and invest in the project. D. 7. 7% and don?t invest in the project.
Business
1 answer:
BlackZzzverrR [31]1 year ago
8 0

IRR function for this problem is 7. 7% and invest in the project

<h3>What is IRR function?</h3>

The Excel IRR function returns the internal rate of return (IRR) for a sequence of cash flows that occur at regular intervals. Determine the internal rate of return. Return was calculated as a percentage. =IRR (values, [guess])

IRR is the interest rate at which the sum of all cash flows equals zero, thus it is useful for comparing one investment to another. In the preceding example, if we substitute 8% with 13.92%, the NPV becomes 0, and your IRR becomes zero. As a result, IRR is defined as the discount rate at which a project's NPV becomes zero.

To know more about IRR function follow the link:

brainly.com/question/24301559

#SPJ4

You might be interested in
In early April 2020, an amendment to the annual budget for 2020 was approved by the city council for inflows and outflows in the
djverab [1.8K]

Answer:

attached below

Explanation:

Given data :

Year : 2020

estimated other financing sources = $20,000 ( premium on bonds sold )

estimated revenues = $12500 ( accrued interest on bonds sold )

approximations in amount of one interest payment = $25,000 ( to be made during 2020 )

attached below is the Budget for the street improvement Bond debt service fund for year 2020

3 0
2 years ago
Green Valley Steel had sales of $1,000,000 and collections of $760,000, leaving a balance of $240,000 in accounts receivable as
sammy [17]

Answer: d

Explanation:

8 0
2 years ago
What is erikson's term for the period during which toddlers (aged 18 months to 3 years) develop independence and autonomy if the
amid [387]
Autonomy vs. shame and doubt is Erikson's term for the period during which toddlers (aged 18 months to 3 years) develop independence and autonomy if they are allowed the freedom to explore, or shame and self-doubt if they are restricted and overprotected. In this stage, they develop an important virtue of “will” where their parents play a major role in molding such quality. For example, they can learn at this stage on how to go to the toilet on their own or even clothe themselves.
3 0
3 years ago
Here are returns and standard deviations for four investments. Return (%) Standard Deviation (%) Treasury bills 4.5 0 Stock P 8.
Jlenok [28]

Answer:

a. Standard deviation of the portfolio = 7.00%

b(i) Standard deviation of the portfolio = 30.00%

b(ii) Standard deviation of the portfolio = 4.00%

b(iii) Standard deviation of the portfolio = 21.40%

Explanation:

Note: This question is not complete. The complete question is therefore provided before answering the question as follows:

Here are returns and standard deviations for four investments.

                                  Return (%)           Standard Deviation (%)

Treasury bills                4.5                                    0

Stock P                          8.0                                   14

Stock Q                        17.0                                  34

Stock R                       21.5                                    26

Calculate the standard deviations of the following portfolios.

a. 50% in Treasury bills, 50% in stock P. (Enter your answer as a percent rounded to 2 decimal places.)

b. 50% each in Q and R, assuming the shares have:

i. perfect positive correlation

ii. perfect negative correlation

iii. no correlation

(Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.)

The explanation to the answer is now provided as follows:

a. Calculate the standard deviations of 50% in Treasury bills, 50% in stock P. (Enter your answer as a percent rounded to 2 decimal places.)

Since there is no correlation between Treasury bills and stocks, it therefore implies that the correlation coefficient between the Treasury bills and stock P is zero.

The standard deviation between the Treasury bills and stock P can be calculated by first estimating the variance of their returns using the following formula:

Portfolio return variance = (WT^2 * SDT^2) + (WP^2 * SDP^2) + (2 * WT * SDT * WP * SDP * CFtp) ......................... (1)

Where;

WT = Weight of Stock Treasury bills = 50%

WP = Weight of Stock P = 50%

SDT = Standard deviation of Treasury bills = 0

SDP = Standard deviation of stock P = 14%

CFtp = The correlation coefficient between Treasury bills and stock P = 0.45

Substituting all the values into equation (1), we have:

Portfolio return variance = (50%^2 * 0^2) + (50%^2 * 14%^2) + (2 * 50% * 0 * 50% * 14% * 0) = 0.49%

Standard deviation of the portfolio = (Portfolio return variance)^(1/2) = (0.49%)^(1/2) = (0.49)^0.5 = 7.00%

b. 50% each in Q and R

To calculated the standard deviation 50% each in Q and R, we first estimate the variance using the following formula:

Portfolio return variance = (WQ^2 * SDQ^2) + (WR^2 * SDR^2) + (2 * WQ * SDQ * WR * SDR * CFqr) ......................... (2)

Where;

WQ = Weight of Stock Q = 50%

WR = Weight of Stock R = 50%

SDQ = Standard deviation of stock Q = 34%

SDR = Standard deviation of stock R = 26%

b(i). assuming the shares have perfect positive correlation

This implies that:

CFqr = The correlation coefficient between stocks Q and = 1

Substituting all the values into equation (2), we have:

Portfolio return variance = (50%^2 * 34%^2) + (50%^2 * 26%^2) + (2 * 50% * 34% * 50% * 26% * 1) = 9.00%

Standard deviation of the portfolio = (Portfolio return variance)^(1/2) = (9.00%)^(1/2) = (9.00%)^0.5 = 30.00%

b(ii). assuming the shares have perfect negative correlation

This implies that:

CFqr = The correlation coefficient between stocks Q and = -1

Substituting all the values into equation (2), we have:

Portfolio return variance = (50%^2 * 34%^2) + (50%^2 * 26%^2) + (2 * 50% * 34% * 50% * 26% * (-1)) = 0.16%

Standard deviation of the portfolio = (Portfolio return variance)^(1/2) = (0.16%)^(1/2) = (0.16%)^0.5 = 4.00%

b(iii). assuming the shares have no correlation

This implies that:

CFqr = The correlation coefficient between stocks Q and = 0

Substituting all the values into equation (2), we have:

Portfolio return variance = (50%^2 * 34%^2) + (50%^2 * 26%^2) + (2 * 50% * 34% * 50% * 26% * 0) = 4.58%

Standard deviation of the portfolio = (Portfolio return variance)^(1/2) = (4.58%)^(1/2) = (4.58%)^0.5 = 21.40%

8 0
3 years ago
A television advertisement shows several teenagers searching through the refrigerator for something to satisfy their hunger. The
Andre45 [30]

Answer:

The answer for the first blank is needs, the second blank is preferences.

Explanation:

The need for sustenance is a primary drive for all living creatures, including humans. The advertisement shows this by casting hungry teenagers who are seeking to fulfill this drive. Since the company producing this advertisement sells Hot Pocket, they wanted to associate ‘fulfilling the hunger drive’ with their product. That way, customers who view this advertisement are more likely to choose Hot Pocket compared to its competitors.  

7 0
3 years ago
Other questions:
  • You work for Whittenerg Inc., which is considering a new project whose data are shown below. What is the project's Year 1 cash f
    6·1 answer
  • (1) You go to Greater's Ice Cream and see the price of a cone quoted as $3.00. (2) You buy the cone and pay with $3.00 in cash.
    8·1 answer
  • inancial information for Forever 18 includes the following selected data: ($ in millions except share data) 2021 2020 Net income
    13·1 answer
  • Analyze if the investment in new equipment is profitable based on the information given below. Cost of new equipment $66,000 Yea
    9·1 answer
  • Suppose that Dr. Reilly owns a medical clinic and enters into a contract to buy some tablets of Gensol from Pharzime. Since Dr.
    10·1 answer
  • O
    15·1 answer
  • A _____ is a person who specializes in matching jobs with people and usually works only with higher level positions.
    5·1 answer
  • ___ is the total sum of benefits a purchasing firm obtains for the price it pays for the marketing offering.
    10·1 answer
  • Within an organizational structure, the person most likely to be evaluated in terms of controllable costs would be:
    13·1 answer
  • Oriole Company uses the percentage of receivables method for recording bad debts expense. The accounts receivable balance is $28
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!