How much will the account be worth

Reference no: EM13933858

Question 1: A store advertises a filing cabinet for a reduced price of $299 after a $50 trade-in on any old cabinet.

(a) What percentage discount does the old cabinet represent?

(b) If the store offers a further discount of 15% off the reduced price for cash, what price (to the nearest dollar) would the cabinet be now after a trade-in?

(c) A customer with a trade-in offers the store a $260 cash price for the cabinet. Is that a better deal (for the customer) than the store is offering?

Question 2: On Mary's 16th birthday, her parents invest on her behalf an amount of $5,000 into an account that pays interest at 3.8% compounded semi-annually.

(a) How much will the account be worth on Mary's 21st birthday?

(b) Would Mary be better off if the account paid interest at 3.6% compounded quarterly? Explain.

Question 3: Luxury Rides Taxi Service must replace cars every 5 years at a cost of $450,000. The company is considering depositing $4,000 at the end of each month at 8% per year compounded monthly. Confirm your answer using EXCEL. Will they meet the target with this strategy? Explain. If your answer is no, what size deposits should they be making instead?

Question 4: Kate and Miles are shopping for a new home. They can afford a downpayment of $50,000 and monthly payments of at most $2,500.

(a) Sterling Bank has offered to finance a loan at 8.75% per year compounded monthly for 30 years. What is the most expensive house (to the nearest dollar) they can afford to buy?

(b) Kate and Miles ultimately make a downpayment of $50,000 on a $300,000 home and finance the balance through Creative Financing Inc. at 8.25% per year compounded monthly for 25 years. What monthly payments should Kate and Miles make to pay off the house?

(c) Referring to part (b), use EXCEL to set up an Amortisation Schedule for the first 12 months of the loan. Attach the printout or copy your EXCEL amortisation into your assignment submission. EXCEL Instructions: Please refer to the amortisation example in Week 3 lecture notes and Topic 3 in the EXCEL Booklet.

(d) Referring to the Amortisation Schedule from part (c), how much interest in total will Kate and Miles pay over the first year of their loan? How much equity (downpayment plus repaid principal) in the house will they have at the end of the first year?

Question 5: Hit-and-Miss Airlines are considering providing a new daily service between two cities. The aircraft has a maximum capacity of 200 passengers and each flight incurs a fixed cost of $27,000 regardless of the number of passangers. In addition, a cost is also incurred of $75 per passenger to cover such things as catering, booking, baggage handling.

(a) The company is thinking of charging $225 per ticket. How many passengers will the airline need on each flight to break even? Find the break-even point algebraically and illustrate it using an EXCEL graph. Attach the printout or copy your EXCEL graph 3 into your assignment submission. Based on your analysis, will Hit-and-Miss realize a profit or a loss if 160 seats are sold for a particular flight? Explain briefly.

(b) EXCEL Instructions: Create a column called Number of Passengers and in that column enter values from 0 to 200 in increments of 20. Then create two more columns, one for Total Cost and another for Total Revenue. Enter appropriate formulae in EXCEL to obtain the total cost and total revenue corresponding to each value in the Number of Passengers column. Highlight the resulting three sets of numbers and go to the Chart Wizard to obtain the graph. Make sure that your graph has been labelled appropriately (i.e. title, axis labels, legend). Please refer to Topic 3 in the EXCEL Booklet for further instructions on entering formulae and graphing in EXCEL.

(c) Hit-and-Miss Airlines know from previous experience that they are unlikely to sell more than 80 percent of seats on any one flight. Assuming they sell exactly this many, what price per seat should they charge to break even?

(d) The company also has the option of accepting a cargo contract. Under this contract, the airline will receive $5,000 per flight for transporting cargo but, because of the extra weight, it will have to reduce its maximum number of passengers to 190. Find the new break-even ticket price for a full flight.

Reference no: EM13933858

Questions Cloud

Policies government can implement to achieve economic growth : Discuss the policies which a government can implement to achieve economic growth. To what extent do you agree that economic growth is always beneficial to a country?

Largest indoor amusement park in the world : On average for the Northern Gate 60% of customers arrives batched as follow 2 at a time, 20% 3 at a time and 20% arrives individually. Analysis shown that 70% of arrivals from both gates will play with FormulaRossagame Which is the fastest Roller..

Production manager to support the production schedule : The purpose of this case study is to apply a number of the key concepts covered in the course textbook to a notional business case. Consider yourself the supply chain manager (SCM) for this company. In this position, you work closely with the plant p..

Social science and psychological sciences research institute : You are a new graduate at a social science and psychological sciences research institute. The researchers have given you a dataset about mental health service providers in America for you to analyse. You will be graded based on the rubric attached..

How much will the account be worth : On Mary's 16th birthday, her parents invest on her behalf an amount of $5,000 into an account that pays interest at 3.8% compounded semi-annually. (a) How much will the account be worth on Mary's 21st birthday?

What is environmental psychology : What is Environmental Psychology? What is an important milestone in the development of environmental psychology? Why is this milestone important?

How do environmental cues shape human behavior : How do environmental cues shape human behavior? How can behavior be modified to support sustainability and how this can limit a negative impact on the environment?

Collected cash from accounts receivable : Collected cash from accounts receivable not within the discount period.

Calculate the diameter d of the spherical lead ball : Calculate the diameter d of the spherical lead ball suspended from the vertex of the buoy so that the base will be 12 in. above the surface of the water.

User Account

All Pages