Finance excel problems — EASY: Excel Answers 2021

Finance excel problems ? EASY: Excel Answers 2021

Question Title:

Finance excel problems ? EASY

Full Question:

Unformatted Attachment Preview

Term Paper
BFIN 305 ? 800: Summer 2019
Submit through D2L. Use only Word and Excel.
25% of your total grade.
Due date: 4th July 2019 at 11:59 pm.
Show detailed calculations and works.
State all your assumptions clearly.
Make observations and comment on your findings.
In this term paper, you will find the value of your undergraduate degree.
Step 1: Calculate the cost of the program
First fill up the following table to list down the term wise tuitions. Some terms are in the past and
some will be in the future (until graduation). This is a term-wise exercise.
Use the start of each term as the time/date (column 1 of the table): 15th January for spring, 15th
May for first summer, 1st July for second summer, and 1st September for fall terms.
Consider all the expenses related to school such as books, fees, etc. as part of Tuition (column 2).
Assuming today to be 1st July 2019, find the time difference (column 3) between today and the
date for each term. Time from today (years) = Time from today (in days)/365
Now find the value of the tuition as on today (column 4). If the term was in the past, you need to
find today?s value in order to find value as on today. If the term is in the future you need to find
the PV (present value) in order to find value as on today. You may use the latest 10 years Treasury
bond rate (https://ycharts.com/indicators/10_year_treasury_rate) as the discount rate. You just
need the latest rate.
For past terms: Value as on today = Tuition * (1 + discount rate) time from today in years
For future terms: Value as on today = Tuition / (1 + discount rate) time from today in years
Finally, add up the last column to find out the PV of the cost of the undergraduate program.
Time/Date
Tuition ($)
Time from today (days)
Time from today (years)
Value as on today ($)
Step 2: Estimate the opportunity cost
Since you are a full time or part time student, you might have (and may be in future) foregone
earnings that you could have earned had you not enrolled in the program. You may be working for
fewer hours a week, or not working at all, or working in a place with lower wage. Find the
difference between what you could have earned and what you have actually earned. Estimate
similar difference for the future months as well, as you continue until graduation. This will be a
monthly exercise (unlike in step 1 which was a term wise exercise). Rest of the directions and
assumptions are similar to as mentioned in Step 1.
Time/Date
Earnings
($)
Could have
earned ($)
Difference
($)
Time from
today (days)
Time from
today (years)
Value as on
today ($)
Finally, add up the last column to find out the present value of the earnings foregone. This is your
opportunity cost.
Step 3: Find out the benefits of the undergraduate degree
In this step we will calculate the monitory value of your degree. This is valued as the difference in
earnings that the degree makes. This is also a monthly exercise. Start this exercise from the month
of graduation and assume that you will be working till 70; you are expected to get a modest pay
rise every year that matches the rate of inflation in the recent months. In every 5 years, you may
expect to receive a moderate/decent pay rise due to promotion or changing jobs. Your earnings
without the degree in the initial months should be in line with the ?could have earned? in Step 2.
Rest of the directions remain same as in Step 1. However, now you change your discount rate to
11% (we are assuming that this rate is commensurate with the risk of your earnings being different
than what you are projecting).
Time/Date
Earnings with the
degree($)
Earnings without the
degree($)
Difference
($)
Time from
today (years)
Value as on
today ($)
Finally, add up the last column to find out the present value of the benefits of having the degree.
Step 4: Calculate the value of your degree
The Present Value of your degree
= Benefits of the undergraduate degree ? Cost of the program ? Opportunity Cost
Step 5: Analysis
A) This exercise requires a number of assumptions to be made by you. Please state all those
assumptions clearly and state your basis for such assumptions.
B) Make observation on your findings. Comment on how your case may be special or different
from other students.
C) State what else could have been included in this exercise
Special instructions:
1. Start early and submit by deadline.
2. Read this instruction very thoroughly. Ask questions only after you have carefully gone
through the instructions.
3. This is a financial exercise. Therefore, ensure that your work makes sense financially.
4. Use MS Excel for all the tables and calculations.
5. Use word document to state assumptions, make comments and observations.
6. Ensure that you show all the calculations and state all the assumptions clearly.
7. After submission, ensure that correct version of all the files have been uploaded.
Today
Discount rate
This is just an example
Time/date Tuition/earnings ($)
Time from today (days)
For a term/month in the past
1-Sep-18
100
303
For a term/month in the future
1-Sep-19
100
62
1-Jul-19
6.00%

Purchase answer to see full
attachment

This question was handled by a Studyhelp247 Excel tutor and the student left a positive review. 19+ custom answers have been given to students for this question in October 2021 alone. To avoid plagiarism and maintain student privacy, we do not resell answers. Get your custom solution now. It is affordable.

Bram Eldoff, Founder, Studyhelp247.com

Consider this Excel Assignment Done
Beat its deadline and stringent requirements.

[advanced_iframe securitykey=?your key? use_shortcode_attributes_only=?true? src=?https://core.studyhelp247.com/main-site-question-post/? id=?example4? height=?350? width=?450? show_part_of_iframe=?true? show_part_of_iframe_x=?-100? show_part_of_iframe_y=?75? show_part_of_iframe_width=?450? show_part_of_iframe_height=?350? show_part_of_iframe_new_window=?_top? show_part_of_iframe_new_url=?https://core.studyhelp247.com/new-question-posting/?]

>Approximate cost: $8 per page.
>Choose your own tutor.
>Get free revision, plagiarism reports, and a list of sources.
>Release the money only after delivery

How it Works

hw

Why you should post this Excel question now.

Flawless Deliveries
Our tutors deliver fault free assignments after careful and detailed research. All instructions are followed to the letter.

100% Originality Guarantee
Every task delivered to students on our platform has 100% originality guarantee. Find plagiarism, get 100% money back.

Timely Deliveries
When you post a question here, we assure on-time delivery, or 100% money back. You cannot miss deadlines with us.

24/7 Customer Support
Our support agents are always online, ready to help you when using our platform. It only gets better.

Student-Friendly Prices
Getting quality help should not break your pocket. Find instant quality help for whatever budget you have.

Free Revisions
You can request your tutor for as many revisions as needed to ensure you are 100% satisfied with our services.

100% Privacy
Every action you take on our platform is anonymous. Once you receive your help, it is almost as if you weren?t here.

100% Refunds
If a tutor breaks any of our guarantees, you get 100% money back to ask questions in the future. No questions.

Here are other questions on different subjects that our tutors have handled with excellent results.

The first ones are Simon Fraser University Promontory Inc Small Business Management Environmental Analysis and HIST 2301 TUW Residential Schools and Their Impact Essay which required in-depth research and computations. The third and fourth ones are Finance excel problems ? EASY and The number of moles of solute present in 1 kg of a solvent is called? SAT Assignment Homework help, which called for experts to help with online quizzes. All these were answered for students who were looking for study assistants for homework help 2021

Reviews from Students; Verified by Trustalyze

Studyhelp247 Exceeded my expectations.

Rated 5 out of 5
3 years ago

I believe in studyhelp247 now. Here, I found the best tutor to assist me with a complex math task. It was seamless using the site.

Avatar for SdfDsf
SdfDsf

Response from Studyhelp247

Thank you for using our platform to find academic help. We are happy that you found what you were looking for.

By far, the best source of affordable custom writing solutions.

Rated 5 out of 5
3 years ago

I came to studyhelp247 after seeing an ad and they have been great. It is quite affordable owing to the fact that there are no service fee charges.

Avatar for Student01
Student01

Response from Studyhelp247

Thank you for the great review. We are committed to providing the best platform to foster student excellennce. 🙂

Very responsive support

Rated 5 out of 5
3 years ago

I have enjoyed using studyhelp247. The support was very responsive and I received quality work

Avatar for Alsalem
Alsalem

Response from Studyhelp247

Thank you.
Our support agents are always available to assist you with any issue.

Great work done for me by Anastacia.

Rated 5 out of 5
3 years ago

Thank you for the great work that you delivered. I will be back for more. 🙂

Avatar for Elsie
Elsie

Response from Studyhelp247

Thank you for using our site.