Activity - Cost of Living Calculator-1

using excelAssume you've graduated and get the dream job and need transportation to go to work (problem definition)-so you need to purchase a car (objective).You would like to analyze your financial options to purchase the car you want andat the same time spent the minimum possible (decision making criteria).You prefer to pay around 3000$/year (requirements)but if it helps to reduce the cost you can pay more.Explore the options of (compare alternatives to save $)  1- Getting a loan of 20K over 5 years at 5%, how much is your yearly payments.                    Hint:  (=PMT(i,n,p)  ) 2- Searching for a better loan at 4%- how much you save?                    (compare total interest paid I1-I2)3- Try to pay up your loan quicker like 3 years-     See how much you save in Interest paid. (compare total interest paid ) 4 - Negotiated the purchase down to 18.5K and see how much you save in interest.        (compare total interest paid  as well as the total paid) 5- Put down more money at the…

Cost Planning; The Cost of an MBA; Time Value of MoneyThe motivation for getting the MBA degree has many aspects—the prestige, greater opportunity for promotion, change of occupation, and increase in pay. To focus just on this last motivation, suppose that you are interested in getting an MBA and are studying the various programs in the United States. You want to balance the costs of getting the degree against the future benefits in increase of pay. You have information on the cost of two MBA programs, which includes the costs of tuition, living expenses, and forgone pre-MBA salary for the two years you are in the MBA program. School A has an average cost of $100,000, and school B, a far more prestigious school at which you think your grades would qualify you to be a suc-cessful applicant, has a cost of $250,000.   RequiredAssume that you have a 10-year planning horizon, that the difference in pay for a job after both schools would remain the same for all 10 years, and the relevant…

Comparing payments and APRs of financing alternatives Because of a job change, Finn McBryde has just relocated to the southeastern United States. He sold his furniture before he moved, so he's now shopping for new furnishings. At a local furniture store, he's found an assortment of couches, chairs, tables, and beds that he thinks would look great in his new, two-bedroom apartment; the total cost for everything is $6,400. Because of moving costs, Finn is a bit short of cash right now, so he's decided to take out an installment loan for $6,400 to pay for the furniture. The furniture store offers to lend him the money for 48 months at an add-on interest rate of 8.5 percent. The credit union at Finn's firm offers to lend him the money - they'll give him the loan at a simple interest rate of 13 percent, but only for a term of 24 months.   Compute the monthly payments for the loan from the furniture store. Round the answer to the nearest cent.________$ per month Compute the monthly…

Hanshaben

Answer the following: You are contemplating a job offer with an advertising agency where you will make 54,000 in your first year of employment. Alternatively, you can begin to work with your father's business where you will earn an annual salary of 38,000. 1. Where will you work?  a. Advertising agency b. Fathers business c. I choose not to work   2. If you choose to work where you will earn most, what is the opportunity cost? a. 54,000 b. 38,000   3. What is the differential revenue?a. 54,000 b. 38,000 c. 16,000

Shanice works in finance for a small manufacturing company and is working on next year’s budget. She has been doing research to compare the cost of outsourcing some upcoming jobs versus the cost of purchasing the equipment to keep the jobs in-house. In what step in financial planning is Shanice involved? Multiple Choice developing financial statements for outside investors forecasting short-term financial needs establishing financial controls and tax policy forecasting long-term financial needs

Maria has a choice between two job offers. The first is in Ithaca and pays $55,000.00 annually. The second job is in Memphis and has a base pay of $45,000.00 with a 10.00% chance of earning an annual bonus of $20,000.00. In which city will Maria, a risk-neutral person, work if the selection is based only on earnings? Ithaca Part 2 ( Feedback See Hint Maria would be indifferent between these two offers if the probability of obtaining the bonus was 0.5 %. (Round to the nearest percent.)

(Comprehensive Problem) Suppose that you are in the fall of your senior year and are faced with the choice of either getting a job when you graduate or going to law school. Of course, your choice is not purely financial. However, to make an informed decision you would like to know the financial implications of the two alternatives. Let's assume that your alternatives are as follows: If you take the "get a job" route you expect to start off with a salary of $40,000 per year. There is no way to predict what will happen in the future, your best guess is that your salary will grow at 4 percent per year until you retire in 41 years. As a law student, you will be paying $30,000 per year tuition for each of the 3 years you are in graduate school. However, you can then expect a job with a starting salary of $80,000 per year. Moreover, you expect your salary to grow by 7 percent per year until you retire 34 years later. Clearly, your total expected lifetime salary will be higher if you become a…

Godo

Suppose you are a cashed-up real estate investor considering purchasing an investment property in Brisbane to buy and then rent out. a) Find a two-bedroom apartment that is advertised for sale (provide a web link to the example). Given the listed (or estimated) sale price of this apartment (use apartment with price of $670,000), what would be the minimum rental income that would make it profitable to invest in this apartment? Make and state your assumptions (e.g., interest/discount rates, maintenance costs).  b) Suppose interest rates went up. Would you now be willing to pay more or less for the same property?

Dog

(Comprehensive Problem) Suppose that you are in the fall of your senior year and are faced with the choice of either getting a job when you graduate or going to law school. Of course, your choice is not purely financial. However, to make an informed decision you would like to know the financial implications of the two alternatives. Let's assume that your alternatives are as follows: If you take the "get a job" route you expect to start off with a salary of $35,000 per year. There is no way to predict what will happen in the future, your best guess is that your salary will grow at 3 percent per year until you retire in 44 years. As a law student, you will be paying $30,000 per year tuition for each of the 3 years you are in graduate school. However, you can then expect a job with a starting salary of $80,000 per year. Moreover, you expect your salary to grow by 7 percent per year until you retire 38 years later. Clearly, your total expected lifetime salary will be higher if you become a…

Please do not give image format

Rerun the NPV analysis for Helen. Did she correctly determine a positive NPV related to her investment for this 8 year period? State the NPV amount. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

Please solve the following

Rent versus buy analysis - Part 2 Which is better: to rent or to buy? The decision of whether to rent or buy housing is a personal decision that is based on both your lifestyle and your finances While most financial experts argue that the financial aspect of the decision. is important, it is also important not to base your rent- or buy decision solely on the numbers. Your personal needs and housing market conditions are important. However, it is still necessary to perform the financial analysis. Tim and his wife are trying to decide whether to rent or to purchase a new townhouse. After looking for several months, they ve narrowed their choice down to one particular house, and the builder is willing to lease or sell-depending upon the preference of the buyer. To perform a rent or buy analysis, Tim and his wife have collected the following information: if they rent, the builder will require monthly rental payments of $1,300 and a security deposit equal to two months of rent Since they…

Brad Edwards is earning $36,000 a year in a city located in the Midwest. He is interviewing for a position in a city with a cost of living 18 percent higher than where he currently lives. What is the minimum salary Brad would need at his new job to maintain the same standard of living? Minimum salary

Suppose that you are in the fall of your senior year and are faced with the choice of either getting a job when you graduate or going to law school. Of​ course, your choice is not purely financial. ​ However, to make an informed decision you would like to know the financial implications of the two alternatives. ​ Let's assume that your alternatives are as​ follows:   If you take the​ "get a​ job" route you expect to start off with a salary of ​$40,000 per year. There is no way to predict what will happen in the​ future, your best guess is that your salary will grow at 5 percent per year until you retire in 45 years. As a law​ student, you will be paying ​$25,000 per year tuition for each of the 3 years you are in graduate school. ​ However, you can then expect a job with a starting salary of ​$75,000 per year. ​ Moreover, you expect your salary to grow by 7 percent per year until you retire 39 years later.   ​Clearly, your total expected lifetime salary will be higher if you become a…