Please write the formula you use in excel and also attach, Ask an Expert

Finance

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

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M9792480

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Company m uses the percentage of sales method of estimating

Company M uses the percentage of sales method of estimating bad debts. At the beginning of the current fiscal year, Company M's allowance for doubtful accounts had a credit balance of $3,000. During the current year, Com ...

1 what is the value today of single payment of 35738 made

1) What is the value today, of single payment of $35,738 made 8 years from today, if the value is discounted at a rate of 17.00%? 2) How many years would it take an investment of $616 to grow to $3,075 at an annual rate ...

1 you are analyzing a common stock with a beta of 28 the

1.) You are analyzing a common stock with a beta of 2.8. The risk-free rate of interest is 5 percent and the expected return on the market is 12 percent. What is the stock's equilibrium required rate of return? Round to ...

What are the steps to solve this question this is a finance

What are the steps to solve this question? This is a Finance question. This is a practice question. I actually already know the answer, I just need to know the steps to get to the answer (72.60). What if Timco's dividend ...

Abc company has projected sales of 19810 in january the

ABC Company has projected Sales of $19810 in January. The sales are expected to grow by 10% each month. ABC's collection schedule is as follows: ABC collects 88 percent of its sales in the month of sale and the remainder ...

Suppose you know that a companys stock currently sells for

Suppose you know that a company's stock currently sells for $60 per share and the required return on the stock is 14 percent. You also know that the total return on the stock is evenly divided between a capital gain yiel ...

The common stock of abc inc has been trading in a narrow

The common stock of ABC INC. has been trading in a narrow price range for the past month, and you are convinced it is going to stay in that range in the next three months. The current price of the stock is $100 per share ...

You observe following exchange rate quotations 1 is equal

You observe following exchange rate quotations: $1 is equal to 6.4568 Chinese yuan 1 Japanese yen equal to 0.0616 Chinese yuan. How many U.S. dollars will you need to purchase 1 billion Japanese yen?

1 you are valuing a common stock that just paid a dividend

1.) You are valuing a common stock that just paid a dividend of $1.25 per share. You are expecting the stock to grow at the rate of 4% annually, and the stock to give you a return of 9%. What should be the price of the s ...

William purchased a 1000 par value bond with a 12 percent

William purchased a $1,000 par value bond with a 12 percent coupon rate and 9 percent yield to maturity. William will hold the bond until it matures. What rate of return will William earn on this investment? 10.5% 12.0% ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert