### Use excel cell formulas

Assignment Help Finance Basics
##### Reference no: EM13868054

This assignment is a basic finance course assignment.

4 out of the 5 questions are already answered. You job is to answer question 5 and to show all working for questions 1-4. The deadline and price are fixed.

There are two parts to this assignment.

2. Use Excel cell formulas, financial functions or algebraic time value of money equations to show the working for the answers in the file.

Attachment:- Workbook1.xlsx

### Previous Q& A

#### What did you do in the revision process?

What did you do in the revision process?

What are some of the advantages and disadvantages to using gas chromatography for the analysis of forensic and/or pharmaceutical samples ?

#### Presentation to persuade an audience to purchase a product

Consider a product or service you highly recommend. Identify your audience. Perhaps you would like to recommend this product or service to accountants? A job recruiter? Cosmetologists? Plumbers? A family member?

#### Assigned julian samora essays

assigned Julian Samora essays

#### Prepare the journal entry to record the bond issuance

Prepare the journal entry to record the bond issuance. Prepare the journal entry to record the first interest payment on December 31. Prepare a bond discount amortization schedule for these bonds. Round calculations to the nearest dollar.

#### Debt and discipline

(1) Debt and discipline. A firm whose management does its best to pay a regular and fixed dividend does not need the discipline provided by debt. Do you agree with this opinion? Briefly explain your answer

#### Determine probability of given event using binomial formula

In a binomial situation, n = 4 and 1r = .25. Determine the probabilities of the following events using the binomial formula.

#### Prepare the journal entry to record the employers fica taxes

Considering both employee and employer payroll taxes, use the preceding information to calculate the total labor cost for the company. Prepare the journal entry to record the payroll for March, including employee deductions (but excluding employer pa..

#### Calculate the rotational constant

Calculate the rotational constant B for H2(g)and D2(g)in unite of frequency. Rationalize the trend inrotational constant for these two molecule ,given the differ only in atomic mass.

#### Information systems for decision making

How your organization can modify its present organizational structures to be more efficient and effective in the future, making better use of information and information systems for decision making

### Similar Q& A

#### What is the best estimate of the stock price per share

f the company has 30 million shares of stock outstanding, what is the best estimate of the stock's price per share?

#### Complete the operating budget assume the 2009 projections

develop a budget for patton-fuller community hospital based on the 2009 operating budget and the 2010 operating budget

#### Find the option price using a replicating portfolio

If we are given a stock (price 1)that we are allowed to trade halfway with probability .5 in which the halfway maturities are 2 and .5, and then the full maturities are 4,1,1,.25 with probability of .5 for each again.

#### Perform a financial analysis of wmt vs tgt

Perform a FINANCIAL ANALYSIS of WMT vs. TGT: Create side-by-side LINE CHARTS with CAGRs for WMT vs. TGT for fiscal years 2007-2014 in SALES, STOCK PRICE, NET PROFITS.

#### What inflation rate is expected after year 1

If the yield on 3-year Treasury bonds equals the 1-year yield plus 2.25%, what inflation rate is expected after Year 1? Round your answer to two decimal places.

#### Sincere stationery corporation needs to raise 500000 to

sincere stationery corporation needs to raise 500000 to improve its manufacturing plant. it has decided to issue a 1000

#### A 5-year annuity of ten 9400 semiannual payments will begin

a 5-year annuity of ten 9400 semiannual payments will begin 9 years from now with the first payment coming 9.5 years

#### Classify the cost as product or variable

The following are expenses are associated with manufacturing firms, merchandising companies, or service companies:

#### What is the net cost of the spectrometer that is what is

you have been asked by the president of your company to evaluate the proposed acquisition of a new spectrometer for the

#### Diversification in stock portfolios

Could you please give a report well supported, in APA format, illustrated with examples about your conclusions in this case study:

#### A repeated-measures study with n 16 participants is used

a repeated-measures study with n 16 participants is used to construct a 99 confidence interval for the population mean

#### What is the maturity risk premium for the 2-year security

The real risk-free rate is 3%, and inflation is expected to be 2% for the next 2 years. A 2-year Treasury security yields 7.9%. What is the maturity risk premium for the 2-year security?