All categories

4 years ago

How do u calculate the bill total for the week by summing the daily bill amounts

Business

1 answer:

tino4ka555 [31]4 years ago

3 0

Answer:

Calculating the bill total for the week:

The Sum Function in excel is a very easy mathematical operation to sum the daily bill amounts. In the cell for the sum, you can manually enter the sum function by typing (=sum), then you define the parameters (=sum(C50:I50). One you press the "enter" the result is automatically displayed. This can also be automatically done by pressing the Sum Function on the Ribbon or Alt + =.

Explanation:

In Microsoft Excel, the Sum Function is a mathematical operation or syntax that provides the formula for adding, subtracting, or getting the total numerical content of indicated cells. With the Sum Function of Excel you can add, subtract, multiply, and divide, for example A1 * A4, C20/A2, A4 - A5, and so on.

You might be interested in

Average Rate of Return, Cash Payback Period, Net Present Value Method for a Service Company

kari74 [83]

Answer:

12.5%

4 years

NPV = $302,387

PV of cash flows = $1,552,387

Amount invested = $1,250,000

Explanation:

Average rate of return = net income / amount invested

Net income = cash flow - depreciation

Straight line depreciation expense = (Cost of asset - Salvage value) / useful life

1,250,000 / 8 = 156,250

Net income = $312,500 - 156,250 = $156250

(156250 / $1,250,000) x 100 = 12.50%

Payback calculates the amount of time it takes to recover the amount invested in a project from it cumulative cash flows

Payback period = Amount invested / cash flow

$1,250,000 / $312,500 = 4 years

Net present value is the present value of after-tax cash flows from an investment less the amount invested.

NPV can be calculated using a financial calculator

Cash flow in year 0 = $-1,250,000

Cash flow each year from year 1 to 8 = $312,500

I = 12%

NPV = $302,387

To find the NPV using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. after inputting all the cash flows, press the NPV button, input the value for I, press enter and the arrow facing a downward direction.

7 0

3 years ago

mcdonalds, burger king, pizza hut and KFc retaurastand all operate in different countries are best characterized as what kind of

Papessa [141]

Answer:

multi-domestic corporation

Explanation:

A multi-domestic corporation are the localized form of multinational corporations. They operate through domestic channels. The management is headed by the domestic operations. The managers and operations are the local personnel who make the decisions and make significant changes in the respective countries. The management of McDonalds, Burger King, Pizza Hut and KFC comprises of the local team in every country. The decisions and regulations are termed in accordance to the culture, environment and market of the particular country.

7 0

3 years ago

Early Head Start Example of

Zielflug [23.3K]

Answer:

To serve infant and toddlers

Explanation:

Early head is a great initiative which is funded by federal government for low income family. It aims to serve infants, toddlers and pregnant women's. This service is generally provided to those families which are having low income. It plays a vital role in social development and cognitive skills which are important for the children's at early stage of their lives.

4 0

4 years ago

How does risk response impact change control management and vulnerability management?

elena-s [515]

Risk reaction impacts change control administration and weakness administration since change control is a sensible approach to draw close to a change. It can dodge the possibility that the system of an association could wind up plainly interfered.

5 0

3 years ago

IBM creates and sells additional stock to the investment banker Morgan Stanley. Morgan Stanley then resells the issue to the U.S

ivanzaharov [21]

Answer: Asset Transformer

Explanation: The above is an example of asset transformation by Morgan Stanley. The transaction itself is an example of a primary market transaction.

An asset transformers (Morgan Stanley in this case) are involved in the conversion of risky assets (IBM stocks, in this case) into safer assets by creating and selling assets with risk characteristics that investors are more comfortable with (E.g. Mutual funds). The funds acquired by selling these assets are used to purchase other assets that may have for more risk and possibility for higher returns.

5 0

4 years ago