Home » Finance Excel Assignment

Finance Excel Assignment

Data – Fact (prices & rates)

Peanuts
Risk Free Rate 5%
Market Risk Permium 7%
Peanuts Beta 3
Possible Peanuts Prices Probability distribution
$ 55.00 10%
$ 59.44 10%
$ 63.89 10%
$ 68.33 10%
$ 72.78 10%
$ 77.22 10%
$ 81.67 10%
$ 86.11 10%
$ 90.56 10%
$ 95.00 10%

Turn-in-page 01.a Assignment

01 Question: What is the expected spot price for peanuts? NAME:
Stephen: Stephen: The expected return is the sum of the probabilities * peanut prices 02 Question: What is the current spot price for peanuts?
Stephen: Stephen: According to CAPM the discount rate is the risk free rate + Beta * risk premium. The spot price is the present value of expected price for peanuts. 03 Question: Create a payoff table and payoff diagram for a long forward and a short forward on a peanut contract with a forward price of $65 and the possible peanut prices listed in the Data – Fact worksheet.
Forward Price $65.00
Future Possible Peanut Prices
States of Peanut Prices
Stephen: Stephen: Use the transpose function to list the possible peanut prices.
Long Forward Payoff
Short Forward Payoff
Chart Here. One series for the long forward and the other series for the short forward.
04 Question: Create a portfolio consisting of a long position in peanuts and a short forward in a peanut contract with a forward price of $65. List the assets in the portfolio, the value of the assets and the total cost of the portfolio. Then create a payoff table showing the portfolio’s final payoff in all possible states.
Assets in Portfolio Long in Peanuts Short Forward Portfolio Value
Value of Portfolio Assets
Future Possible Peanut Prices
States of Peanut Prices
Long Peanuts
Short Forward Payoff
Portfolio Payoff

Turn-in-page 01.b Assignment

05 Question: If the forward price is $ 65 then is there a risk free arbitrage opportunity? If there is an arbitrage opportunity then list the assets in the portfolio and detemine if you taking a long position in the asset or a short position. Determine the total cost of the portfolio. If you are recieving funds from the portfolio then make the cost negative.
Forward Price $65.00 NAME
Assets in Portfolio Portfolio Value
Value of Portfolio Assets
06 Question: Based on your answer from question 5 create a payoff table for your portfolio.
Future Possible Peanut Prices
States of Peanut Prices
Portfolio Payoff
07 Question: Using Goal Seek determine the forward price that will cause the arbitrage opportunity to disappear. Copy your answer below and reset Questions 5’s forward rate back to $65
Hard copy forward rate here.
08 Question: What is the forward price using the formula you learned in class?
09 Question: Does the forward price equal the expected spot price?
10 Question: Determine the Beta that will set the forward price equal to the expected spot price. Besure to set the beta in the Data-Fact worksheet back to 3 after answering this question!!.
Stephen: Stephen: I would suggest using goal seek to answer this question.
Hard Copy Beta value here
11 Question: At what discount rate will the forward price on peanuts equal the expected spot price on peanuts. (Hint look at question 10)
Stephen: Stephen: What is the discount rate when you use Question 10’s Beta?

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Live Chat+1 763 309 4299EmailWhatsApp

We Can Handle your Online Class from as low as$100 per week