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
PIT_PIT [208]
3 years ago
9

Financial functions format calculated values as currency, with _______. Question 3 options: a) positive cash flow appearing in r

ed font b) positive cash flow enclosed in parentheses c) negative cash flow appearing in green font d) negative cash flow appearing in red font
Business
1 answer:
Vlada [557]3 years ago
3 0

Answer:

d) negative cash flow appearing in red font.

Explanation:

Colour coding is a type of excel formatting for financial modelling.

Color coding allows anyone to immediately pick up your model and know what can be changed (assumptions) and what should not be altered (formulas).

Example:

negative cash flow (Cash outflow) of the company appears in red font while positive cash flow (Cash inflow) of the company appears in green font.

You might be interested in
Cullumber, Inc., has outstanding bonds that will mature in six years and pay an 8 percent coupon semiannually. If you paid $1,03
Sedbober [7]

Answer:

The worth of the bond is $1068.44

Explanation:

Solution

Given that

Supposed that the face of the bond is $1000

Thus

The semiannual coupon payment = 1000*8%*6/12

= 40 (semiannual period in a year comprising of 6 months each)

Then

Semiannual periods = 6 years *2

=12

The semiannual yield = 6.6*6/12

= 3.3%

So,

The present value of bond = (PVA3.3%,12*semiannual coupon payment) + (PVF3.3%,12*Face value)

=(9.77808*40) + (.67732*1000)

=391.12+ 677.32

=$1068.44

The worth of the bond is $1068.44

nnote: Find present value factor using the formula 1/(1+i)^n  

(Where i = 3.3%, n= 12 ) or using financial calculator by putting i = 3.3%,n=12 and FV= 1

Also, Find present value annuity factor using the formula [1/(1+i)^1 +1/(1+i)^2 +......+(1+i)^11+1/(1+i)^12 ] or using financial calculator where i = 3.3%,n= 12 and PMT =1

6 0
3 years ago
Canadian Beer reported equipment sold for $258 million cash and new equipment purchased $1,533 million cash. The equipment sold
RideAnS [48]

Answer:

The answer to this question can be defined as follows:

Explanation:

Please find the table in the attached file.

An inflow of $258 million and an outflow of $1,533 million.

The cash outflow for $1,533 is reported separately for investment activities and cash outflow for $2,58 is reported. The number of revenues received is indicated as the inflow.

7 0
3 years ago
Read 2 more answers
If a company would need to increase net working capital to start a potential new project how should it be treated in the project
natali 33 [55]

Answer:

C

Explanation:

Working capital is the capital used in the daily running of a business.

Working capital = current assets - current liabilities

Working capital is a form of expenditure for the firm.

Thus it is an outflow.

Working capital should be recorded after tax. tax should be subtracted from working capital to determine the eventual outflow

An increase in working capital means more cash is being used in the business. this cash cannot be used elsewhere. this reduces the amount of cash the business can use for other activities. this is why it is an outflow

7 0
3 years ago
Even Better Products has come out with an even better product. As a result, the firm projects an ROE of 20%, and it will maintai
TEA [102]

Answer:

Price $17

PE ratio 8.5 times

Explanation:

As per given data

ROE = 20%,

Plowback ratio = b= 0.03,

EPS = $2,

k= 12%

As plowback referr to the retentrion value, deducting its effect from EPS

Dividend= EPS × ( 1 − b ) = $2 × ( 1 −0.03 )= $1.94

Growth = ROE x b = 20% x 0.03 = 0.006 = 0.6%

Using Dividendvaluation method we will calculate the price.

Price  = Dividend  / (Rate of return - Growth rate )

Price  = $1.94  / ( 12% - 0.6% ) = $17

P / E Ratio = Price / EPS = $17 / $2 = 8.5

6 0
4 years ago
What strategic goal can an IS attain that does not involve wresting market share from competitors? Provide some business example
pishuonlain [190]

Provide some business examples. The strategic goal which an IS can attain without involving wresting market share from competitors by following certain measures like: By lowering the price of units to sell while maintaining the quality of the products. By offering new products and services.

6 0
3 years ago
Other questions:
  • Regan grows flowers and makes ceramic vases. Jayson also grows flowers and makes ceramic vases. Regan can produce 3 times as man
    5·2 answers
  • June Daye lives in the southern part of Alabama where winters are normally fairly mild. Last January, during an unusually cold s
    11·1 answer
  • For observation to be a useful skill, what are 2 key points to avoid "cluttering" your mind with unimportant information?
    9·1 answer
  • The value of the goods and services Australia purchases from the U.S. are less than the value of goods and services the U.S. pur
    10·1 answer
  • Morgan Company issues 8%, 20-year bonds with a par value of $740,000 that pay interest semi-annually. The current market rate is
    11·1 answer
  • K. Mello Company has three employees-a consultant, a computer programmer, and an administrator. The following payroll informatio
    7·1 answer
  • Liberty Insurance Company processes applications forms. The average output in a week is 600 claims. Currently the staff includes
    14·1 answer
  • Mom &Pop Inc. has a demand forecast for the next 6 month. It can currently produce 2000 units per month and each worker can
    11·1 answer
  • An importing business is involved in international business when it buys goods from other countries and sells them in
    15·1 answer
  • According to the OOH, what educational, training, certification, or licensing requirements do Physicians and Surgeons need? Chec
    8·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!