User Account

All Pages

How much money will you have in account in ten years

Assignment Help Financial Accounting
Reference no: EM131330625

Business Finance Assignment

Tasks to complete:

1. Download and save the Excel file, "Excel_Assignment". The file is located in the Excel Assignment folder.

2. Save the file to your own drive and rename the file with your last name and first name.

3. The Excel file contains worksheet tabs, one for each problem. Complete each problem by entering your answer in the indicated space. Use Excel formulae, functions, and cell referencing (when possible) to complete each problem. DO NOT solve the problem using a calculator and then type the answer in Excel, this will result in "0" credit for the problem.

4. Submit your answer file on Blackboard by the deadline.

Fair warning: file sharing is an act of academic dishonesty. See policy in the syllabus.

Question 1

You want to buy a $300,000 house. You plan to make a down payment of 20% of the purchase price and finance the rest with a 30-year fixed rate mortgage loan. The loan is fully amortizing, and requires monthly payments at the end of each month. The nominal loan rate is 5%, compounded monthly. 1) How much of the purchase price will you finance with the mortgage loan? 2) What is your anticipated monthly mortgage payment?

Question 2

Suppose that you deposit $200 at the end of each month into an account paying an expected annual rate of return of 3%, compounded monthly. How much money will you have in the account in 10 years?

Question 3

An investment offers to pay you $300 per quarter for 10 years. If the annual rate is 11% with quarterly compounding, then what is the present value of these cash flows?

Question 4

You currently have $4,000 in a bank account that pays a nominal rate of 1%, compounded monthly. You plan to make additional monthly deposits of $200, starting at the end of this month. How many payments will you have made when your account balance reaches $50,000?

Question 5

A basketball player is offered the following contract today, Jan. 1, 2012: $2 million immediately, $2.40 million in 2012, $2.90 million in 2013, $3.60 million in 2014, and $3.80 million in 2015. Assume all payments other than the first $2 million are paid at the end of the year. If the appropriate discount rate is 10 percent per year, what is the present value of the deal?

Attachment:- Excel_Assignment.xlsx

Reference no: EM131330625

Questions Cloud

What is yield to maturity of this bond : A Japanese company has a bond outstanding that sells for 88 percent of its ¥100,000 par value. The bond has a coupon rate of 4.7 percent paid annually and matures in 18 years. What is the yield to maturity of this bond?
Discuss about the automotive fuel additives : Discuss about the automotive fuel additives and their properties.
Write a research proposal : Write a research proposal of approximately 2,000 words that includes the sections - Include a minimum of five sources, which may consist of readings from the University Library, your text, and other selections.
What is the company enterprise value : FFDP Corp. has yearly sales of $28.4 million and costs of $12.7 million. The company’s balance sheet shows debt of $54.4 million and cash of $38.4 million. There are 1,960,000 shares outstanding and the industry EV/EBITDA multiple is 7.9. What is the..
How much money will you have in account in ten years : FINA 314: Suppose that you deposit $200 at the end of each month into an account paying an expected annual rate of return of 3%, compounded monthly. How much money will you have in the account in 10 years?
No dividends will be paid on stock over next nine year : Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock over the next nine years, because the firm needs to plow back its earnings to fuel growth. The company will pay a dividend of $15 per share in 10 years and ..
Book about heart of darkness : Five outside sources and include a paragraph of concession and rebuttal that both contributes to your credibility and helps your reader better understand your position
Describe emmsion components operations : Describe emmsion components operations and how to test their operation.
Minimum number of servers for system : What is the minimum number of servers for this system? What is the optimal number of servers for this system from a cost perspective? What is the cost for the system, per hour, with the optimum number of servers?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Tradition of keeping information about clients confidential

Swiss banks have had a long tradition of keeping information about their clients confidential. Is this the correct strategic focus to take in the 21st century? Should the United States government have the right to demand information pertaining to the..

  The interest rate implicit in the lease

A lease of a plant asset was signed on January 1 several years ago and was appropriately capitalized by both parties. At 12/31 of the current year, At the same date, the lessor reports a $460,000 gross lease receivable balance, and a $60,000 unearned..

  Quantity of shares for what might appear to be bargain price

Lou Hoskins and Shirley Crothers are organizing Red Lodge Metals Unlimited Inc. to undertake a high-risk gold-mining venture in Canada. Lou and Shirley tentatively plan to request authorization for 400,000,000 shares of common stock to be sold to the..

  Variable factory overhead cost associated with cases

Eclipse Computer Company has been purchasing carrying cases for its portable computers at a delivered cost of $65 per unit. the company which is currently operating below full capacity charges factory overhead to production at the rate of 40% of dire..

  Opportunity to invest

Most Company has an opportunity to invest in one of two new projects. Project Y requires a $315,000 investment for new machinery with a four-year life and no salvage value.

  Effect on the company total net operating income

Elbow Corporation uses part B76 in one of its products. The company's Accounting Department reports the following costs of producing the 12,000 units of the part that are needed every year. Prepare a report that shows the effect on the company's tota..

  Determine the manufacturing costs added

Using the information below for Laurels Company; determine the manufacturing costs added during the current year: Direct materials used $5,000 Direct Labor 7,000 Total Factory overhead 5,100 Beginning work in process 3,000 Ending work in process 4,00..

  Compute the amount of cash payments to suppliers

Blackmon Company reported net income of $805,000 and cost of goods sold of $1,525,000 on its 2009 income statement. Compute the amount of cash payments to suppliers.

  What tax consequences will result from the transactions

Kasinda is a partner in Twins Partnership. At January 1, 2015, her 25% partnership interest has an adjusted cost base of $35,000. During 2015, she withdraws $85,000 from the partnership. During 2015, the partnership has business income for tax purpos..

  Statements concerning the accounting for leases

Which of the following statements concerning the accounting for leases is not true?

  Prepare a cash budget for each of the six months

Prepare a cash budget for each of the six months to 31 December 2009, showing the cash balance at the end of each month - Describe the objectives of budgetary planning and control systems.

  Discuss how your understanding of balance sheet

Discuss how your understanding of the balance sheet and income statement may applied to your current or future position. paper must be APA format and double space.statement must come in first before the numbers.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd