FINANCIAL MANAGEMENT - Achiever Papers

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?

Sheet1

Financial functions Use example example formula reference rate() calculate interest rate of an annuity what is the interest rate for a loan of $100 if it can be paied off in 12 periods with payment of $10 at the end of each period 3%

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.18

https://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.86

https://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.58

https://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

Turn in your highest-quality paper
Get a qualified writer to help you with

“ FINANCIAL MANAGEMENT ”

Get high-quality paper

NEW! AI matching with writer

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 form

Once 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 assignment

As 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