due 16

**Homework 1**

READ BEFORE YOU START: **Solve each of the following question using both pricing formulas and Excel.** When calculating using the pricing formula (e.g., Price of perpetuity P = C/r), please write the original formula and the steps where you plug in the number for each variable, and your final answers. When solving it using Excel, learn from the Excel functions file and show the results displayed in formula.

1. If you wish to accumulate $150,000 in 10 years, how much must you deposit today in a bank account that pays an annual interest rate of 12%?

2. A zero-coupon bond has a face value of $21,000 and a maturity of 8 years. Similar bonds have an interest rate of 5% per year. What is the price of this bond?

3. You plan to retire in 35 years. At the end of each year, you plan on saving $15,000, and your bank pays you 2% annual interest. How much will you have saved by the time you retire?

4. A bond with a face value of $1,000 pays a 10% (APR) semiannual coupon and matures in 10 years. Similar bonds trade at a YTM of 8% (APR). What is the price of the bond?

5. You are managing a small company and need to buy some equipment for your product line. Kangaroo Manufacturing is offering free credit on a $20,000 piece of equipment. You pay down $2,000 and then $600 a month for the next 30 months. Turtle Machines does not offer free credit but will give you a $2,000 off the list price. If the rate of interest is 10% (APR) a year, which company is offering a better deal?

https://exceljet.net/excel-functions/excel-rate-function

fv() find future value of fixed payments what is the future value of 5 payments of $20 at the end of each period, assuming we have $0 in our pockets now and interest rate of 3%? ¥106.18https://exceljet.net/excel-functions/excel-fv-function

pv() find present value of fixed payments what is the price of a bond that pays 5 $20 coupons and principal payment of $100, using an interest rate of 3%? ¥177.86https://exceljet.net/excel-functions/excel-pv-function

npv() find net present value of cash flows what is the net present value of $10, $20, and $30 at today, tomorrow, and two days later using a discount rate of 5%? ¥53.58https://exceljet.net/excel-functions/excel-npv-function

pmt() find fixed payment what is the amount of payment at the end of each period if we want to pay down $100 to $20 in 5 periods, assuming interest rate of 5%? ¥26.72 https://exceljet.net/excel-functions/excel-pmt-function nper() find number of periods how many periods (of payments) do we need to make if we want to pay off $100 by $20 payment at the end of each period, assuming interest rate of 5%? 5.8963128604 https://exceljet.net/excel-functions/excel-pmt-function

https://exceljet.net/excel-functions/excel-rate-function

https://exceljet.net/excel-functions/excel-fv-function

https://exceljet.net/excel-functions/excel-pv-function

https://exceljet.net/excel-functions/excel-npv-function

https://exceljet.net/excel-functions/excel-pmt-function

https://exceljet.net/excel-functions/excel-pmt-function

Essay Writing Service Features

- Qualified Writers
- Flexible pricing
- Plagiarism-free papers

- Anonymity
- Timely delivery
- 24/7 customer support

Our Experience

No matter how complex your assignment is, we can find the right professional for your specific task. Achiever Papers is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.Free Features

Free revision policy

$10
Free

Free bibliography & reference

$8
Free

Free title page

$8
Free

Free formatting

$8
Free

How Our Dissertation Writing Service Works

First, you will need to complete an order form. It's not difficult but, if anything is unclear, you may always chat with us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.

Complete the order formOnce we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.

Writer’s assignmentAs soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.

Completing the order and download