Category: Finance

Financial Project
As an Ivy Tech student, you are making an investment in your education. This project will look at how that investment
will pay off if you graduate and get a job in your desired field. You will be comparing your future finances with someone
who is not a college graduate. Assume that the median annual income for a person who is only a high school graduate is
$31,760 (although this may not be accurate for Indiana residents). Use this value in comparison statements with proper
absolute and relative change statements.
In this project you are required to do the following:
Create an Excel spreadsheet to help calculate the correct values for housing and retirement. Reach out to your instructor
if you need assistance with how to find mortgage or retirement values. You will use the PV, FV, PMT formulas in Excel.
Your typed responses for this project will consist of answering short-answer questions given below. Each short-answer
should be a minimum of 3 sentences and 50 words. Use proper quantitative reasoning and wording to address the
solution. This should clearly convey your message to a reader who is not taking Math 123. Make sure to use your Word
document to answer “what if” questions with specific values and provide support for your statements. To do this, make
changes in your spreadsheet and analyze the results of the manipulations – be quantitative and specific with correct
absolute and relative change statements. Your answers to these questions will be typed in a Word document and
submitted in IvyLearn using the link to Project 2.
HINT: As you are writing your absolute or relative change sentence, make sure to address “more than” or “less than”
what value. Writing sentences such as, “The absolute/relative change is this value…” will NOT be counted as correct.
What is the meaning of an absolute or relative change in each scenario?
1. Answer the two following questions related to your median annual salary and that of the high school graduate:
 Explain what job you have chosen and what has inspired you to pursue a career in that field. Use the
median salary from the following website: https://www.bls.gov/ooh.
 How does your salary compare to the high school graduate using BOTH an absolute change and relative
change statement?
Car Loan
2. Assume you can afford to use 11.5% of your monthly gross income towards your monthly car payment. The
terms of the loan are 9.35% APR for 7 years.
 What is the highest price car you can afford based on the information above? Be sure to show and explain
the Excel formula you used.
 What is the highest priced car the high school graduate can afford based on the same information? Be sure
to show and explain the Excel formula you used.
 Use an absolute or relative change statement to compare the highest priced car of the high school graduate
and yourself.
Retirement Account
3. Assume that your selected job has a retirement plan that allows you to save for 37 years.
Math 123 Quantitative Reasoning Project Due 7 March 2024
 If 5.55% of your monthly income is put into a retirement account, how much should you expect if the
average annual return is 6.42%? Be sure to show and explain the Excel formula you used.
 Using the same conditions, determine the amount a high school graduate should expect to have in their
retirement account? Be sure to show and explain the Excel formula you used.
 Use an absolute or relative change statement to compare the retirement accounts of the high school
graduate and yourself.
4. Assume you are saving for retirement with the same stipulations as before (5.55% of your income at a rate of
6.42% for the account).
 How long would it take for your account to reach $1 million dollars? (Keep your answer in years.)
 How long would it take a high school graduate to reach $1 million dollars? (Use years for this also.)
 Compare the amount of time taken to reach $1 million for you and the high school graduate. Use an
absolute change sentence to compare your answers.
Salary Increase
5. Your employer offers 2 options as an increase to your salary for the next year:
Option 1: You can have a 2.25% increase of your median annual salary.
Option 2: You can take an increase of $1500 added to your median annual salary.
 Find the new annual salary for both Option 1 and Option 2 for the college graduate. Show your calculations.
 Which option should you choose as a college graduate? Explain why using an absolute change or relative
change statement in your response.
 Find the new annual salary for both Option 1 and Option 2 for the high school graduate. Show your
calculations.
 Which option should the high school graduate choose? Explain why using an absolute change or relative
change statement in your response.

Why do many firms object to paying for foreign currency option hedges? Do firms pay for forward contract hedges? How do forwards and options differ, if at all?

Wk 4 Summative Assessment: Financial Market Shareholder Analysis
A company’s financial reports are used for a variety of reasons, including determining how the company is doing in the financial market. You decide to evaluate the effects of economic and market conditions on your company’s financial performance. Completing this exercise provides you with financial market research to present to your management team to inspire new KPIs and policies.
Assessment Deliverable
Use the previous year’s financial reports research you completed in Week 3.
Write a 2- to 3-page shareholder analysis in which you address the following:
Evaluate economic conditions that influence company performance. Consider political, environmental, currency (money), global economics, and government influences on economic conditions.
Compare market conditions from the previous year with the company’s performance for that same year. Conclude how the market conditions that year influenced the company’s performance, such as interest rates, Federal Reserve Bank monetary policy changes, or other market conditions relevant to the company you selected.
Analyze year-over-year performance from the past two years. Consider key metrics or ratios such as trailing PE ratio, forward PE ratio, price to book, return on assets, and return on equity in your conclusions.
Cite references to support your assessment according to APA guidelines.
Submit your assessment.
Assessment Support
Rubric for guidance on deliverable expectations
University of Phoenix Library Finance Resources
Yahoo! Finance

You may use Excel Price Functions as well as any of the “COUP…” functions Your solution should work after changing any of the Blue inputs. The Horizon period should work for up to 9 years. Make a Scroll Bar that changes the Horizon Date between 2 and 9 years in the future (from the Settlement Date) – NOTE: Set the Horizon Date to 6/21/2029 when submitting for Grading Make a Data Table and a Graph of RCY as a function of the number of years to the Horizon ($I$2). Use the RCY you computed on the sheet (not your function) and make years go from 2 to 9. Write a VBA function that uses each of the numbers in the BLUE input fields below to compute the RCY. The same rules apply as in step 1. NOTE: To use “COUP…” functions in VBA. You need to write “worksheetfunction.COUP…”

Using the company Apple provide a detail outline of the research project. Include in your submission a bibliography of a least 4 scholarly sources for the research project. Research project instructions:
The specific objective of this course project is to assure that students of business have a sufficient capacity of skills to conduct an organizational financial analysis. This exercise will provide students with the opportunity to integrate and implement theory to practice.
For the purpose of this exercise, students will choose a company for which they will perform the following tasks:
An environmental scan and risk analysis of the organization both companies.
A financial statement analysis of the organizations utilizing ratios.
Comparison discussion on both companies based on ratios calculated.
A calculation of the weighted average cost of capital. (Information will be provided in class)
Develop a cogent conclusion as to the financial health of the organizations, with the idea recommending whether the company’s stock should be bought, sold, or a neutral position taken.
The written paper is to be typed, double–spaced, 1-inch margins, Times New Roman and 12-point font, average content page length is between 10-12, with correct spelling and grammar, proper citation, references, with a cover page and organized with headings

The purpose of this project is to apply some of the concepts covered in the course. Specifically, the
project requires you to develop a simple retirement plan. The approach you should take when
completing this project is that the only funds you receive at retirement are those you contribute to
specific retirement funds—that is, you should assume Social Security will not be available when you
retire. In other words, the only funds you will have available at retirement will include amounts you
have already accumulated in investments that are specifically designated for retirement and any amounts
you accumulate in the future.

OVERVIEW & PURPOSE OF THIS PROJECT
Trading with options is so much more profitable than just trading stocks, and it′s a lot easier
than most people think. This project lets you work on option trading using real financial data.
Idea underlying this project is for you to replicate the spreads and combinations learned in class
and speculate. At the end, we would want to create as much profit as possible (but it’s okay if
we were not able to)
I am sending email seprately
Trading with options is so much more profitable than just trading stocks, and it′s a lot easier
than most people think. This project lets you work on option trading using real financial data.
Idea underlying this project is for you to replicate the spreads and combinations learned in class
and speculate. At the end, we would want to create as much profit as possible (but it’s okay if
we were not able to)
Find the right stock. You want to find a company that you are interested in and have a good
insight on.
 Try to stick with industries you understand: if you enjoy shopping, look at retailers. If you
love gaming, look at game software company, etc. This will make your research a lot easier
and lead to a better stock pitch.
 Qualitatively, try to choose the best/worst company in that industry
 Quantitatively, use arbitrary parameters to filter out stocks. For example, you can select
certain criteria (i.e. market cap, P/E, ROE, industry, etc.) and it spits out list of companies
that meet the criteria. Free online stock screeners include Yahoo Finance, Google Finance,
and Capital IQ. (e.g. Yahoo Finance screener: https://finance.yahoo.com/screener/new/ )
SOURCES OF INFORMATION
1. General financial sites
 Yahoo Finance, Google Finance, MSN Money, Bloomberg terminals, WSJ.comWHAT TO DO :
 Replicate the following spreads/combinations: bull spread, bear spread, butterfly spread,
straddle, strip and strap by using call and/or put options
 FIN 463 individual basis: Replicate at least THREE of the aforementioned
spreads/combinations
WHAT SHOULD BE INCLUDED IN YOUR PAPER (similar to the given example
below):
1. SCREEN CAPTURE: Screen capture the option pricing information as in the example below on a
“traded date”. Then, choose which option information you need in order to create relevant
spread and/or combination. Note that you’d need to choose an expiration date that is before
the last day of class.
2. INFORMATION TABLE: Create a table to write down information of the options you have
used
3. PAYOFF/PROFIT TABLE & GRAPH OF YOUR CHOSEN TRADING STRATEGY: Create a
payoff/profit table and its graph for your spreads and combinations, respectively
4. ACTUAL PROFIT/LOSS AT EXPIRATION DATE: When expiration date reaches, find out
whether your spreads and combinations created a profit or loss. How much was your
total profit/loss?
5. BRIEF ANALYSIS & DISCUSSION: Discuss or suggest how you would have been made a
(larger) profit with the respective spreads/combinations : e.g. used different strike
prices? Different option types? Different positions?
Don′t forget to choose an option with expiration date that is at least on or before the final due date of the project! which is The due date for the project is april 17 ASSUME WE ARE DEALING WITH EUROPEAN OPTIONS (i.e. you can exercise the options at expiration date only)
This project is for you to utilize actual real finance data to replicate spreads and combinations
Please let me know if you need any more details.

This project is the totality of the work done in your portfolio. It is a summary of all the movement, decisions, and activity within your portfolio.
For the final course project, you will create a Summary Document that includes:
Introduction: (1-2 Paragraphs)
This section should give an overview of portfolio management and give an overview of the basic thought process of your personal portfolio.
Body: (at least 2 Pages) Should include most of the following points:
A desсrіption of the portfolio’s performance over the course of the term, including the up and down weekly swings.
How current events impacted the portfolio.
An analysis of the portfolio based on the topics presented during the term.
Thought processes that affected your investment decision(s). An indication of whether you would “buy more”, “hold”, or “sell”.
Lessons learned and/or recommendations for future investments.
Include at least 2 references to peer-reviewed journals.
Summary: (1-2 Paragraphs)
A brief summary of the portfolio, importance of proper management, etc.

Integration Case Study.
The instructions require you to complete an Excel analysis and write up an Executive Summary for this Case Study. PLEASE NOTE: This assignment requires you to generate a series of simulations using the Random Number Generator (instead of the RAND() function) as taught in Module 4. Each team is expected to have unique simulations. Therefore use the last four numbers of one of the team members CWID as your random seed. Please indicate the random seed and which team member CWID was used in both the comments for submission and in your write-up.

Based on previous work done in class, you need to analyze all these and then create a Process Pitch presentation for the Entrepreneurship class.
These are all the previous assignments in chronological order. Just look through them and create a Process Pitch, Process Pitch Instructions are attached separately as a PowerPoint File. Your job is to create a PowerPoint that looks nice and has less text on the slides and MORE speaker notes. It should be MAXIMUM 5 minutes, so after you make the PowerPoint, I will present it myself.
1. https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHIKMnPyS3Qr80uLdAtKiwryi1OVagE
2. https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHLSEjNzSotSdYtSi0tzU5VqAQ
3. https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHIKivKTclJzi3Xz8kt0gZyU0uSSYqVaAA
4. https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHIyU1ITc3STS4tL8nNTi4qVagE
5.
https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHKSSosz81KLi3Vz81NSc3STilITs1Pyy_OUagE
6. https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHISM3Uz80pSi8oyU8uVagE
7.
https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHJK8nXTU0t0kzLTdYtLEotKdItzE3NylGoB
8. https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHIq80uLdFMTi3IqdRNT8gtKUouKlWoB
9. https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHIy80pSi8oyU8sz89J1E5NLMvPzdAtyEvOUagE
10. https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHIy80pSi8oyU8t1kzNSk7ML8oECSrUA
11.
https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHKKS3NzE4syqzLz0nUz80pSi8oyU8uLlWoB
12. https://docs.google.com/presentation/d/1slPl-Dhc0ronCW_dAGce5Kd6iuinmLKDBR8ZAUHTzuY/embed
13. https://teachinge.org/exec/sub/view?sid＝q1YqzUxRslIyMrcwMVXSUUqtAHKK83NKSzLz83QzU1ITQQylWgA