Please write the formula you use in excel and as well

Assignment Help Finance Basics
Reference no: EM13477304

Please write the formula you use in excel and also attach the excel answers.

a) With interest rate 8%, calculate the PV of following cash flows.

Year

Payment

PV

1

1,000

 

2

1,000

 

3

1,000

 

4

1,000

 

5

1,000

 

b) You borrow $10,000 today with interest rate 7%, and you plan to pay the bank back with 8 equal annual payment. Please fill up the following table.

Year

Principal
beg. year

Payment
end year

Interest

Principal

 

 

 

 

 

1

 

 

 

 

2

 

 

 

 

3

 

 

 

 

4

 

 

 

 

5

 

 

 

 

6

 

 

 

 

7

 

 

 

 

8

 

 

 

 

Reference no: EM13477304

Questions Cloud

Your firm is contemplating purchase of the new 600000 : your firm is contemplating the purchase of a new 600000 computer-based order entry system. the system will be
The system needs the initial investment in net working : franks is looking at a new sausage system with an installed cost of 530000. this cost will be depreciated straight-line
Used the data given and computed the average thickness of : you are a quality analyst with john and sons company. your company manufactures fax machines copiers and printers that
An explanation of how the advertisement will reach target : individual portionprepare a presentation of 10-12 powerpoint slides with 150-200 words of speakers notes per slide to
Please write the formula you use in excel and as well : please write the formula you use in excel and also attach the excel answers.a with interest rate 8 calculate the pv of
The project is estimated to generate 2110000 in annual : keiper inc. is considering a new three-year expansion project that requires an initial fixed asset investment of 2.79
Winnebagel corp presently sells 32000 motor homes per year : winnebagel corp. currently sells 32000 motor homes per year at 70000 each and 13000 luxury motor coaches per year at
Company name- high-tech international is consulting : company name- high-tech international is a consulting establishment which specializes in marketing of high-technology
The site requires 720000 worth of grading before it is : parker amp stone inc. is looking at setting up a new manufacturing plant in south park to produce garden tools. the

Reviews

Write a Review

Finance Basics Questions & Answers

  Analyze the effects of financial and trade globalization

Write a paper summarizing the document and to also make a power point presentation and explain and talk about what the paper is about. Make sure to include any graphs, tables, formulas or statistics in the power point presentation.

  What is the value of brushy mountains stock

As a result, the company's earnings and dividends are declining at the constant rate of 5% per year. If D0 = $6 and rs = 18%, what is the value of Brushy Mountain's stock? Round your answer to the nearest cent.

  Describe a residual dividend policy

Compare, contrast, and discuss the amount of dividends (calculated in part b) associated with each of the three capital expenditure amounts.

  Calculate the stocks expected return and standard deviation

Calculate the stock's expected return and standard deviation

  What is the return on the stockholders equity

If the firm has an asset turnover ratio of 4.0 times, what is the profit margin (return on sales)?

  Determining suitable allocation rates

What are the suitable allocation rates? Use the allocation table to assign hospital’s overhead costs to patient services departments.

  What will be the firm quick ratio

How much can a company's short-term debt(notes payable) increase without pushing its current ratio below 2.0? What will be the firm's quick ratio after Nelson has raise the maximum amount of short-term funds?

  Compute the appropriate discount rate

The NuPress Valet Corporation has an improved version of its hotel stand. The investment cost is expected to be $72 million and will return $13.5 million for five years in net cash flows.

  Compute the value of the bond

A company has a bond issue outstanding that pays $150 annual interest plus $1000 at maturity. The bond has a maturity of 10 years. Compute the value of the bond when the interest rate is 5%, 9%, and 13%. Describe the pattern and the type of risk t..

  Value of the tax benefits from depreciation

The cost of capital is 14 percent, and the firm's tax rate is 40 percent - Estimate the present value of the tax benefits from depreciation

  Compute the future value of this cash flow stream

Assume interest rate of 8%. A company receives cash flows of $542 at the end of year 5, $275 at the end of year 7, and $691 at the end of year 10. Compute the future value of this cash flow stream.

  The frn has quarterly coupons equal to three-month

Takeda Development Corporation has issued a $100 million floating rate note (FRN) that will mature in three years. The FRN has quarterly coupons equal to three-month LIBOR,

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd