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

Aluminium window infill panels - 10 breton court ballajura - Spanish 2 - Microwave waveguides and components - Week 9 - Peter johnson 8000 police scanner - Apc back-ups es 700 beeping - Intro to quadratics worksheet - Background and Geography Guidelines - Gardner's leadership attributes - Effective Communication with Diverse Audiences - Lumo energy price fact sheet - Save smog city 2 from ozone worksheet answers - This question is based on the following circle graph - Hawke cable gland spanners - Informational report vs analytical report - Two case studies - Polytechnic west midland courses - Signals and systems laboratory with matlab pdf - Color blind powerpoint slides - Example of swot analysis for human resources department - Global wellness economy monitor 2019 pdf - Governments often intervene in international trade and impose quotas to - Rcd testing requirements nsw - Identifying Threats and Vulnerabilities in an IT Infrastructure - A paper mill uses a control chart to monitor - Cadburys aztec bar advert - Actron air control panel - Microbiology essay questions and answers pdf - Snhu it 210 milestone 2 - HA575 Unit 10 Discussion - Ati capstone maternal newborn assessment - Who invented the permanent wave - Combustion experiment with limewater - Difference between qualitative and quantitative research sampling strategies - Gucci target market 2019 - Electrical maintenance training ppt - Dr sam mckewin cairns - Homelessness in california essay - Newly revised strong interest inventory - Why does methylene blue turn colourless - ASSIGNMENT 1 - I need physics help - Joe soap car wash price list - Designing team and team identity articles - Cognitive behavioral therapy group settings versus family settings - Pros and cons of gainsharing - Lead and manage team effectiveness - Endless summer chapter 13 initials - Cfg to pda solved examples - What are the moral problems of a globalized world today - Potassium chromate hydrochloric acid - Masonic 2nd degree questions and answers uk - Frequently used logistics techniques - Adam levine tells shakira to shut up - Gibbs free energy worksheet - Chamberlain enterprises inc reported the following receivables - Tweeter etc case analysis - Fujitsu display link driver - Emotional intelligence involves all of the following abilities except - What modifies existing software according to the business's or user's requirements? - Fnce30003 - international finance - Mat 510 case study 2 - Sand rail steering setup - Abercrombie and fitch sydney - Mock drill observation checklist - Barriers of communication powerpoint presentation - Hobart stickmate lx 235 manual - C304 task 1 - Niche differentiation capsim - Romanticism in frankenstein chapter 6 - Elementary Calculus - ________ refers to the effect of unpleasant and undesirable stressors. - Pressure drop in plenum box - Balance of payments tutor2u - Kings international removals pty ltd - Shipley institute of living scale answers - Flexicraft rubber expansion joints - Supertoys last all summer long comprehension questions - SUCCESSFULL UNIVERSITY - Reaction Paper (Short Paper) - Lloyd's syndicate pseudonym list - Present condition of the australian rainforest - Evaporation and intermolecular forces - 10 of 1200 words - What are the 3 main branches of science - It follows movie ending explained - Whittlesey dog training club - Projectile motion experiment conclusion - Organizational hierarchy chart of mobilink - Low noise instrumentation amplifier - What type of account unearned revenue - For Essays Guru - - How to find angle of banked curve - Recurrent laryngeal nerve supplies - Askamp amp com au - Words with 3 consecutive letters of the alphabet - Beth gelert poem summary - Segmentation criteria used in identification for lemonade - Only connect em forster