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

19/12/2020 Client: saad24vbs Deadline: 2 Day

Math 123 Quantitative Reasoning Project Fall 2020


C:\Users\NicoleGonzalez\AppData\Local\Microsoft\Windows\INetCache\IE\5VVS3GK8\MC900185740[1].wmf 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. You will be creating this project entirely in EXCEL.


1) 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.


2) 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.


3) 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.


· Project should be your original work. Copying someone else’s work is cheating. Sharing your work with someone else is cheating.


Submit an Excel file following your instructor’s directions for submission.


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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
University Coursework Help
Homework Guru
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.

$110 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$112 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$112 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.

$115 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

Kp sports under armour - 2 methylpropene + hbr - Qld teachers meritorious sick leave - What is security association in ipsec - Dupont stop program review - Main reasons for the great depression - What did theodor schwann discover - Soap Note x 3 (24 Hours) - Www bbc co uk schools typing level 1 4 - Editing symbols for writing - Noli me tangere tagalog story - Powerpoint - Personas select sí or no to indicate which of the following words you hear in the narration. - Apa cultural formulation interview - Strength of welded joints ppt - Notice for breach of duty to landlord of rented premises - PSYCHOLOGY PAPER - Construction of helmholtz coils - R & b specialty printing tupelo ms - Health Assessment Topic Reflection4 Musculoskeletal and Extremities - Winter solstice hilda morley analysis - Carlton dh100 dehumidifier manual - Cozy wall heater won't turn on - Rounding to significant figures - The book thief synopsis - Monsanto attempts to balance stakeholder interests case study answer - History - Rate my teacher st colmans college - Eli ginzberg career choice theory - Critical pedagogy axiology - Mixed pair share kagan - Balance sheet in good form sample - Ch3oh strong or weak electrolyte - Was elvis a twin - How to pass the slla exam - Cloud computing Assignments - Network diagram critical path questions - Bargain hunt experts kate bateman - Roman hanging punctuation illustrator - EBP Part 5 - ***For C. Owens Only*** - Old fashioned skirt support crossword clue - Controlling hot money - Acute red eye ppt - Animal farm argumentative essay - Air meals is a company that prepares - Short drama script about family problems - Colin davis machine company maintains a general ledger account - Cross price elasticity of demand tutor2u - Nm 1fe fx v2 - Moral and ethical issues of enclave tourism - Trimdek foam infill strips - Frank lloyd wright organic architecture - Composition and rhetoric - Mental Healt Care Plan - Bug off exterminators accounting problem - Phys lab - A highly available and scalable web service - Electric field mapping lab report - Acme bathroom exhaust fans - Crown employees conditions of employment award - The Intervention and Assessment Model - Viburnum odoratissimum var awabuki - The following measurements were recorded for the drying time - Student resource otter history homework - What is the revision stage of policy process - Which of the following is an accurate statement about sports and the media? - Medieval social system crossword - Swanson's theory of caring - Ideal citizen in a totalitarian government - Scu blackboard login - Case 9.1 all indian logistics services answers - Vce methods grade distribution - Ap statistics test a gathering data part iii answer key - Community organizing training manual - Acid base titration neutralization reaction lab report - How do i learn best questionnaire - What hr metrics are you familiar with - Weapons Webography - Thinnest layer of the earth - SWOT Presentation & Reflection Essay - Ariamx real time pcr system - Chapter 13 investments and fair value accounting answers - Lab 1 introduction to science exercise 1 data interpretation - Standard 5 care certificate answers - Advanced Construction - 401 - Steam enters an adiabatic turbine at mpa - Examples of unethical behavior in budgeting - Emotional resilience in social work - Who are the major developers of cybersecurity related inventions - Emphatic verb tense worksheet - Discussion Responses - Desert survival activity answers - Teuer furniture - Emily eyefinger duncan ball - Nursing management of pregnancy induced hypertension - Warner company's year end unadjusted - Ap statistics chapter 1 test - Find acceleration due to gravity from slope of graph - World Perspectives Week 1