In Excel an Excel spreadsheet with formulas. Five years ago you purchased a 10 year U.S. treasury

Fantastic news! We've Found the answer you've been seeking!

Question:

In Excel an Excel spreadsheet with formulas.

Five years ago you purchased a 10 year U.S. treasury note for $6,500. You receive $125/year in interest. Principal of $6,500 paid in full at the end of 10 years

What was the rate of return (yield) when you purchased the note?

What would be the price of the note today?

If you sold the note today, what would be your rate of return?

Under what circumstances would you decide to sell the note? Keep it?

Related Book For answer-question

Fundamentals of Corporate Finance

ISBN: 978-1259024962

6th Canadian edition

Authors: Richard Brealey, Stewart Myers, Alan Marcus, Devashis Mitra, Elizabeth Maynes, William Lim

See More Books

Posted Date: Jan 27, 2024 08:51 AM

See More Questions

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
Microsoft is planning to introduce a new Xbox model next year. Microsoft estimates that the new model will generate the following cash flows (in millions): Year 0 Year 1 Year 2 Year 3 Year 4 -203 165...
A production function describes a.how a firm maximizes profits. b. the minimal cost of producing a given level of output. c.how a firm turns inputs into output. d. the relationship between cost and...
Three resistors are connected in series across a battery. The value of each resistance and its maximum power rating are as follows: 2.0 and 4.0 W, 12.0 and 10.0 W, and 3.0 and 5.0 W. (a) What is...
An editorial in the Economist magazine discusses the fact that in most countries-including the United States-it is illegal for individuals to buy or sell body parts, such as kidneys. a. Draw a demand...
Write the numeral as a traditional Chinese numeral. 4260
How do you prevent name clashes when using header files?
Frevert purchased a new piece of equipment to be used in its new facility. The $370,000 piece of equipment was purchased with a $50,000 down payment and with cash received through the issuance of a...
A company is planning to purchase and store two items, gadgets and widgets. Each gadget costs $2.00 and occupies 2 square meters of floor space; each widget costs $3.00 and occu pies 1 square meter...
Which method of representing quantities involves discrete steps?
The following flipped' decision tree corresponds to a decision problem involving two alter- native decisions D = {d, d} and three states of the environment X = {, 2, 3). Several numbers are omitted...
Ivanhoe Company receives a $73,800, 5-year note bearing interest of 11% (paid annually) from a customer at a time when the discount rate is 9%. Click here to view the factor table. (For calculation...
I am writing a Bachelor's thesis and I have collected data through qualitative interviews with 12 customers: 6 who prefer to buy groceries online and 6 who prefer to buy groceries in the physical...
What social need is fulfilled by the establishment of an urban garden. Use the market failure approache (externalities, public goods, imperfect information, etc) to justify. Details: your local...
A block of mass m = 14,6 kg is attached to the free end of a light string wrapped around a reel of radius R = 0, 38 m and mass M = 8,7 kg. The reel is a uniform disk and fixed on an axis about which...
Opening to trade expands an economy's consumption possibilities, so there is a way to make everybody better off. We see that trade makes off some people worse off, while others are made better off....
A company that produces USB memory sticks has been receiving complaints from its customers about the large number of devices that will not store data properly. Company management has decided to...
What will be the final value of DI after executing the following piece of code? Execute the instructions dependently one after another. CLD MOU CX,OFOH MOU AX.02874H MOU DI,01000H MOU ES, DI SUB...
Return to problem l. Suppose the year-end stock price after the dividend is paid is $36. What are the dividend yield and capital gains yield in this case? Why is the dividend yield unaffected? In...
If cash flows change unpredictably, the firm should allow the cash balance to move within limits. a. What three factors determine how far apart these limits are? b. How far should the firm adjust its...
On the Brandex Inc. SFP as the year-end 2013 the share capital was $1,100,000, retained earnings were $3,000,000, accumulated other comprehensive income was $400,000, and total equity was $4,500,000....
Go to the Web site for the Software Engineering Institute of Carnegie Mellon University at https://resources.sei.cmu.edu/asset_files/SpecialReport/1994_003_001_16265.pdf and access the software...
The majority of the project budget is expended upon: a. Project plan development. b. Project plan execution. c. Project termination. d. Project communication.
Which of the following is the most critical component of the triple constraint? a. Time, then cost, then quality. b. Quality, then budget, then time. c. Scope. d. They are all of equal importance...

In Excel an Excel spreadsheet with formulas. Five years ago you purchased a 10 year U.S. treasury

Question:

Expert Answer:

Formulas Cell Formula Description B1 A11A2A1A3A4 Present Value of Investment Price Today B2 A11A2A1A... View the full answer

Fundamentals of Corporate Finance

Students also viewed these finance questions