Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

Accounting


Home >> Accounting Basics

Question: Solve the following questions by using Excel formula. Show me your data

1. If you deposit $20,000 in a bank account that pays 15% interest annually, how much will be in your account after 6 years?

2. If you are planning to invest your money today in a secuirty that pay you $5,000,000 in 15 years with rate of return on your investment of 10% annually. How much you should invest?

3. What's the future value of 7%, 7-year ordinary annuity that pays $500 each year? If this was annuity due, what would its future value be?

4. You borrow $85,000 from a bank, the annual loan payments are $8,273.59 for 15 years. What interest are you being charged?

5. Your father asked you to begin a habit of saving money early in your life. He suggested that you put $6 a day into an envelope. Your grandfather further suggested that you take that money at the end of each year ( after 365 days) and invest it in an online brokerage mutual fund account that has an annual expected return of 9%%.
Today you are 18 years old. If you start following your father's advice today, and continue saving in this way for the rest of your life, how much do you expect to have in the brokerage account when you are 62 years old.

6. Find the present value of the following cash flow streams at 8% compounded annually.

7. You have a chance to invest $3,615.14 in a fund that pays fixed payment at the beginning of each period for 4 years. You could earn 6% on your money compounded semiannually. How much you expect to receive at the beginning of each period for the annuity?

Information related to above question is enclosed below:

Attachment:- FM-Assignment1onEXCEL.rar

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M93112638

Have any Question? 


Related Questions in Accounting Basics

Question - domingo entity entered into a contract to

Question - Domingo Entity entered into a contract to exchange a liability. However, this particular liability does not have a quoted price in Domingo's principle market. Sabado Entity holds an asset similar to the liabil ...

Question 1 jazeera publishing house produces consumer

Question: 1. Jazeera Publishing House produces consumer magazines. The house and home division which sells home improvement and home decorating magazines, has seen a 20% reduction in operating income over the past nine m ...

Question - sharp tables produces go carts designed to a

Question - Sharp tables produces go carts designed to a customers specification with the customers logo. Job 65 consists of producing 40 carts for race around for a new store opening. Overhead is applied on the basis of ...

Questions -q1 at december 31 2018 lyndseys boutique had

Questions - Q1. At December 31, 2018, Lyndsey's Boutique had 1,000 gift certificates outstanding, which had been sold to customers during 2018 for $75 each. Lyndsey's business operates on a gross profit of 60 percent of ...

Problem - thakin industries inc manufactures dorm furniture

Problem - Thakin Industries Inc. manufactures dorm furniture in separate processes. In each process, materials are entered at the beginning, and conversion costs are incurred uniformly. Production and cost data for the f ...

Informatics and financial applicationsbackgroundthe

Informatics and Financial Applications Background The assignment of a payroll calculator demonstrates Excels ability to automate and present financial calculation information clearly. The ability to build and professiona ...

Question - explain legislation and statutory requirements

Question - Explain legislation and statutory requirements and industry codes of practice including(Australia): Consumer credit code Privacy act Credit act Financial transaction reports act Corporations act (including acc ...

Question - ross company had the following inventory at the

Question - Ross Company had the following inventory at the end of the year:   Quantity Unit Price Cost Market Valves:       Model Q 180 $11 $9 Model R 150 10 12 Model S 120 7 9 Gaskets:       Model Alpha 60 100 105 Model ...

Question - why is net income before tax the most common

Question - Why is net income before tax the most common base used to determine the preliminary judgment about materiality? In what circumstances might the auditor use a different base?

Question - x company estimates the following for its three

Question - X Company estimates the following for its three products, A, B, and C, for 2018:   A B C Revenue $47,460 $24,303 $63,666 Total variable costs 29,400 18,224 26,136 Fixed costs in 2018 are expected to be $19,800 ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved