### 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

#### Describe some alternatives measures of a firm''s performance

Performance Measures. Describe some alternatives measures of a firm's overall performance. What are their advantages and disadvantages? In each case discuss what benchmarks yo

#### What should the price of your bond be

You have a treasury bond that pays \$100 one year from today and \$1,100 two years from today. You notice that the yield-to-maturity on a one year-zero coupon treasury bond is

#### Calculate the npv of the project using single future value

Calculating Costs and Break-Even Night Shades, Inc. (NSI), manufactures biotech sunglasses. Calculate the NPV of the project using the single future value calculated in the pr

#### No nighttime snack

A dietician decides to study the "no nighttime snack" diet systematically to determine if such a diet has a significant effect on weight. She obtains a random sample of late

#### Discuss systematic and unsystematic risk

Discuss systematic and unsystematic risk, which can be diversified and why? Also discuss some measures of systematic risk and how they can be used to maximize returns and m

#### Type of the option contracts

On Aug 10th, Ali expected that Tower stock price will increase during the coming two months. Therefore, he purchased an option for \$4 per share; exercise price was \$40 per s

#### Computation of npv for a project

This question is from Finance as well as it is about computation of NPV for a project where a new machine is to be bought by the company as well as use it for 4 years. Depen

#### Calculate next year ending receivables balance

A firm is planning to lower its ACP by ten days next year. Receivables are currently \$15M on credit sales of \$120M Credit sales are expected to grow by 20% next year. Calcul