Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Math 123 quantitative reasoning answers

04/01/2021 Client: saad24vbs Deadline: 3 days

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. You will be creating this project entirely in EXCEL.


Income Comparison: Research your expected income after you graduate. Assume you obtain whatever level of education needed to enter your desired area of employment. We recommend using the annual Median salary found at: http://www.bls.gov/oes/current/oes_in.htm#27-0000 *You will need to click on your desired career in order to see the Annual Median wage. If using a different source, you must cite it.


State what your desired area of employment is and what the median annual salary for that position is. Why did you choose this career? How much schooling is needed for this job?


Make at least one statement comparing your expected salary with that of the median income of an unskilled worker. Please use absolute and relative change statements as they are an excellent way to compare values. Assume that the median annual income for an unskilled worker is $15,500, use this value in comparison statements.


Housing Comparison: Assume that you and your unskilled worker counterpart plan to spend 1/4th (25%) of your gross monthly income on house payments. Research the current fixed rate APR for mortgages and choose one that might fit your needs. Most people will use a 30 year mortgage, however, you may use a 15 year mortgage if you wish. Then use Excel to determine the largest value of a mortgage that each of you can afford to borrow under those conditions.


Your answer should contain at least one statement comparing the value of the house that an unskilled worker can afford and that you expect to be able to afford. (Remember to use absolute and relative change here).


Explain what Excel function was used for these calculations. Cite what source you used to find mortgage rates.


Research housing costs in an area where you would like to live. Will your future salary allow you to afford the house you want, or should you consider other housing options? How much more or less must you spend to get the house you want? Cite what source you used to find housing costs.


Retirement Comparison: 401k investments are expected to earn a 4.5% annual return. Assume that 6% of your gross monthly income is to be set aside for 401k investment. Use Excel to determine the balance on such a 401k after 40 years of investment for the unskilled worker and for your expected income.


Your answer should contain at least one statement comparing the value of the 401k investment of the unskilled worker and for your expected salary.




Explain what Excel function was used for these calculations.


Also use Excel to determine how many years it would take for the unskilled worker and for your expected investment to reach $500,000. Your answer should contain at least one statement comparing the time it would take for the 401k investment of the unskilled worker and for your expected salary to reach $500,000.


Project Checklist:


Project must contain some absolute and relative change statements.


Explanation of career choice and the salary for this career.


Comparison of your expected salary vs. an unskilled worker.


Comparison of house you could afford with expected salary vs. unskilled worker.


Explanation of how house value was determined.


Reflection on the housing costs and researched house values.


Explanation of how the 401k value is determined.


Comparison of length of time it would take to achieve $500,000 in retirement funds.


Explanation of how the time to reach $500,000 is determined.


An organized spreadsheet with clearly labeled values.


Completed project should be submitted via Ivy Learn on time.


In addition to addressing the statements above, your project should:


Contain your name, course name and project name.


Be well organized and easy to follow.


Be clear to by someone who is not familiar with the project.


Provide support for your statements e.g. explain how values were found.


Give specific values (i. e. quantify statements).


Use appropriate representations (tables, color, formatting) that helps the reader understand the project.



Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Helping Hand
Top Essay Tutor
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$100 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$105 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Best cv template for data analyst - Summative assginment - Marketing malpractice the cause and the cure summary - Week 7 activity - Double pole relay wiring - Dhl courier charges domestic - BSBWHS401 Implement and monitor WHS POLICIES. - Industrial health and hygiene ppt - MARISSA JONES ONLY!!! - Saunders an imprint of elsevier inc - Accident investigation techniques basic theories and applications - Hanuman gada found in sri lanka tv9 - Longest word in reverse alphabetical order - ?same-day +27833173182 MALKERNS - MANZINI ABORTION CLINIC // PILLS,,,, - Aaron evans architects ltd - Ancient egyptian makeup tools - Studio art study design - St john action plan - Hilder v associated portland cement - Geological history of uluru - Conservation of energy at the skate park answer key - Business values of ikea - Hexapod in a sentence - Owa qub ac uk - Quasi historical documentary about famous rock musicians and their careers - Mdu medical elective indemnity - 15.14 duty of a nurse in any setting - Power point - Bio rad mini protean 3 system glass plates - How much fat is in potato chips experiment - Faustino inno dy v biography - The damnation of a canyon by edward abbey - Mini Research Paper - Apple upgrade program return phone - Cruelty in a christmas carol - Intro to American Politics Class: News Story Analysis - Mechanism of intramolecular aldol condensation - How many cars are sold a day - Abiotic and biotic factors of grasslands - John pomerantz leslie fay - Unit 7 Discussions (ECO202) & (SOC101) - Catholic saints - Queensland kindergarten learning outcomes - 1 atm is how many torr - What did anthropologist george gmelch note about baseball as an activity? - Harry potter dracula fanfiction - Horstmann h27xl series 2 wiring diagram - Consider the following cost information for a pizzeria - Waren sports supply balance sheet 2017 - Quality associates inc case study solution - Four leadership styles of path goal theory - Marble density kg m3 - Post its notes on a marriage summary - The kansas city preventive patrol experiment - Black jack bitumen primer - Wisdom sits in places chapter 4 summary - Annotated bibliography for Security Challanges in Cloud computing (at least 5 references) - Applying Measurement Tools to a Practice Problem - Discussion 2 - Performance Appraisal Process Evaluation - 640w2D1 - Know your rights group australia - Changing our lives thesis statement - OUTLINE - Bangladesh police aig list - Spiritual needs assessment interview questions - My heavenly father watches over me jimmy swaggart - Lorain morning journal police blotter - How to determine volumes from contour lines - Business law - Contact dermatitis soap note - Deploying an ovf with nvram is not supported - Safety in the laboratory worksheet - Problem statement for event management system - Car rental activity diagram - Lg hom bot square price in india - Chemistry planning question o level - Nursing theories - Keith schleiger net worth - Erik erikson psychosocial stages activity worksheet answers - Writing assignment - Is david muir meryl streep's son - LEGAL Week 2 - Short Essays - Journal entry 32 on course - Red hill doctors surgery - Differences between chinese and american culture essay - Simplifying expressions involving multiplication - Ted talk about addiction - Hris needs assessment - Phi 103 week 4 journal - Writing Discussion - Http www satac edu au tafe sa - Lazy dollars - Ways in which data integrity can be compromised - How to increase your writing speed during exams - Which of the following best represents psychology's basic goals - Additivity of heats of reaction hess's law answer key - Favorite Movie - How is confidentiality ensured using the ipsec vpn protocol? - Full wave bridge rectifier waveform - Python rss feed parser example