Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Financial Project Due: I As an Ivy Tech student, you are making an investment in your education. This project will look at how that investment
Financial Project Due: I 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 high school graduate is $23,000 (although the actual value is higher). 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 sheet to help calculate the correct values for housing and retirement. Although this is not a graded part of the project, only excel can produce the correct result (and not a simple calculator for most questions). Ask your instructor if you need to submit an excel template. Refer to the excel help in the book or notes in your course on how to find mortgage or retirement values. You will use the PV, FV. PMT formulas in Excel. Your written portion of the project will consist of answering short answer questions given below. Each short answer solution should be a minimum of 3 sentences and 50 words. For each, use proper quantitative reasoning and wording to address the solution. This should include sophisticated and elegant solutions to clearly convey your message to the reader. Make sure to use your spreadsheet 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. 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..." will NOT be counted as correct. What is the meaning of an absolute or relative change in each scenario
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started