RSS
 

Posts Tagged ‘math’

math of investing spreadsheet?

16 Jul

Ok, I know the formula for future value.
MYMONEY=C2*(1+F2)^G3
C2 = Source $$
F2 = Interest rate
G3 = Periods.
All 3 can be adjusted for what iffs.

G3 usualy changed to 5,10,20,22 (yrs to retirement)
to see what the $$ will be in a future time.

I built the spreadsheet to see if I could let the inheritance pay certain bills … but I assumed the periods would be yearly.
I forgot that the investments pay off more often.
I relize using a yearly period is very conservative to what funds would actually earn over a years time?

How would u adjust the above, with what Ive given here?

Dont give editorials about interest rates etc..I have averaged 10%-18% for decades..(and during certain years did better).
My dad has done 12-20% for at least 8 years.
But I agreee that the calculation above should be unusually conservative.

 
1 Comment

Posted in Uncategorized

 

Future Value -Math – Accounting?

05 Jun

Please help me solve the following questions.

1. Determine the yield to maturity to the nearest tenth of 1 percent of a zero coupon bond with 8 years to maturity that is currently selling for $404.

2. If a 16 year old high school student put $2,000 at the end of each year for 4 years into an IRA that earned a rate of 9%, how much would she have accumulated by age 65? Assume funds are left to accumulate for 45 years (age 20 – 65) at 9%.

 
1 Comment

Posted in Uncategorized

 

Future Value Math Question?

04 Jun

Find the Future Value of an annuity. Given the periodic PMT=$2000, i=0.005, n=30. Round all final answers to the nearest penny.

 
1 Comment

Posted in Uncategorized

 

Math Problems.. Need help! 10pts!?

30 May

10 points to the person who can answers these correctly first!!

When interest is added to the principal and interest is again calculated on the new balance, the process is known as compound interest. (Points: 2)
a.) True
b.) False

2. The terms of a loan indicate how often interest is compounded. (Points: 2)
a.) True
b.) False

3. A compound interest table shows the compounded amount per dollar of principal. (Points: 2)
a.) True
b.) False

4. To compound daily means to compound 360 times a year. (Points: 2)
A.) True
B.) False

5. The effective rate of a transaction can be calculated by dividing the interest for one year by the principal. (Points: 2)
A.) True
B.) False

6. The term “nominal rate” means the same as “true rate.” (Points: 2)
A.) True
B.) False

7. The interest on $4,200.00 at 8% compounded semiannually for 10 years is $6,292.40. (Points: 2)
A.) True
B.) False

8. The effective rate is: (Points: 2)
A.) the stated rate
B.) the nominal rate
C.) the true semiannual rate
D.) the true annual rate
E.) none of the above

9. In a loan of 8% compounded quarterly, what is the periodic interest (Points: 2)
A.) 2.5%
B.) 6%
C.) 2%
D.) 4%

10. Present value does not: (Points: 2)
A.) find the present dollar amount
B.) use the tables
C.) know the present dollar amount
D.) know the future value
E.) none of the above

11. Bill deposits $16,500.00 into the National Bank which pays 10% interest that is compounded semiannually. By using Table 10-1, what will Bill have in his account at the end of 5 years? (Points: 2)
A.) $26,786.76
B.) $26,876.69
C.) $6,876.67
D.) $26,573.42
E.) none of the above

12. Josh is having difficulty deciding whether to put his savings in the Mercantile Bank or the Boatmen’s Bank. Mercantile offers a 10% rate compounded quarterly while Boatmen’s offers 12% compounded semiannually. Josh has $40,000.00 to invest and expects to withdraw the money at the end of 5 years. (Use Table 10-1 from the textbook.) The best deal is: (Points: 2)
A.) Mercantile Bank
B.) Mercantile Bank for the last two years
C.) Boatmen’s Bank for the first two years
D.) Boatmen’s Bank
E.) none of the above

13. Don deposited $27,500.00 in Trader’s Bank at an interest rate of 12% compounded quarterly. (Use Table 10-1 from the textbook.) The effective rate was: (Points: 2)
A.) 12.55%
B.) 12%
C.) 13%
D.) 14.0%
E.) none of the above

14. Lisa wants to attend the University of Colorado. She will need to have $80,000.00 five years from today. Lisa is wondering what she will have to put in the bank today so she will have $80,000.00 in five years. Her bank pays 10% compounded quarterly. By using Table 10-3 in the textbook, the amount Lisa will need to deposit is: (Points: 2)
A.) $48,281.68
B.) $49,113.60
C.) $48,821.60
D.) $49,113.06
E.) none of the above

15. John estimates that he will need $15,000.00 for new equipment in 10 years. John decided that he would put aside the money now so that in 10 years the $15,000.00 will be available. His bank offers him 8% interest compounded semiannually. (Use Table 10-3 from the textbook.) How much must John invest? (Points: 2)
A.) $6,845.85
B.) $36,175.71
C.) $6,584.80
D.) $6,845.08
E.) none of the above

 
1 Comment

Posted in Uncategorized

 

I need help finding the future value of this math problem can anyone help?

28 May

When I was considering what to do with my $10,000 Lottery winnings, my broker suggested I invest half of it in gold, the value of which was growing by 8% per year, and the other half in CDs, which were yielding 2% per year, compounded every 6 months. Assuming that these rates are sustained, how much will my investment be worth in 11 years? (Round your answer to the nearest cent.)
FV$__________
What do I do in this problem that has two interest rates?

 
1 Comment

Posted in Uncategorized

 

Consumer Math Help Plzzz?

26 May

1. What type of reports do Equifax, TransUnion, and Experian produce?(1 point)
income studies
credit reports
crime rate statistics
bankruptcy filings
2. How long does a negative notation on your credit report last? (1 point)
one year
ten years
seven years
forever
3. When buying or selling a used car, what’s the best resource on finding an accurate price? (1 point)
Cheryl Red Book
Kelley Blue Book
Paul Pink Book
Newspaper Advertisements
4. If you drive more than 15,000 miles each year, you should lease a car instead of buying one. (1 point)
True
False
5. 401-K’s and IRA’s are examples of what? (1 point)
Debt Consolidators
Stock Markets
Retirement Accounts
Checking Accounts
6. What type of insurance pays you a monthly cash benefit in the event you’re injured and cannot work? (1 point)
Automobile Insurance
Long Term Care Insurance
Disability Insurance
Life Insurance
7. Your annual household income is a part of your credit score calculation. (1 point)
True
False
8. A credit card is an example of what kind of credit: (1 point)
Deferred
Revolving
Interest-Free
Recurring
9. If you have a low credit score, you’ll pay more for insurance. (1 point)
True
False
10. An individual who prefers high risk investments with a (possibly) high-reward is called: (1 point)
Risk-finding
Risk-taking
Risk-seeking
Risk-searching
11. Wealthy people and companies that invest money in startup companies in exchange for a large share of future profits are called what? (1 point)
Venture capitalists
Loan sharks
Loan officers
Risk-averse
12. When someone prefers to invest and participate in the founding of new companies instead of investing in savings instruments or the stock market they would be called what? (1 point)
Risk-averse
Entrepreneurial
Unilateral
Risk-finding
13. What federal program makes sure your bank deposits are never lost due to bank bankruptcy? (1 point)
The Federal Deposit Insurance Corporation
The World Bank
The Securities and Exchange Commission
The Federal Reserve Bank
14. What is the single best way to increase your long-term income? (1 point)
receive a promotion
receive a merit pay increase
increase your educational level
invest in startup companies
15. What is the best way to decrease your expenses? (1 point)
pay down any outstanding credit cards
get a smaller apartment/house
sell your automobile
diversify
16. Which of the following expenses would be considered discretionary expenses? (1 point)
rent
electricity
credit card payments
magazine subscriptions
17. When an asset (something of value) is always connected to the ground and cannot move – it is called what? (1 point)
Liquidated
Real Property
Collateral
Real Estate
18. Expenses such as electricity, telephone service, and water service are called what? (1 point)
Bills
Debt
Utilities
Revolving Credit
19. The money you pay to an insurance company to insure your property or asset is called what? (1 point)
An insurance premium
An insurance deductible
An insurance payment
Insurance coverage
20. When an asset (something of value) such as an automobile or home is voluntarily sold for cash, it would be considered what? (1 point)
Refinanced
Liquidated
Collateral
Repossessed
21. Documentation from an insurance company that states what item or property is insured and the amount that you will receive if the property is destroyed is called what?

(1 point)
An insurance premium
An insurance declaration
An insurance policy
An insurance deductible
22. An Emergency fund should be made up of what? (1 point)
Real property
Savings instruments
Stock
Cash Only
23. The amount of money you’re likely to make in a lifetime is called what? (1 point)
tax bracket
income potential
taxable income
equity
24. When inflation is high, on a daily basis the money in your pocket becomes what? (1 point)
Worth more
Worth less
Liquidated
Discretionary spending
25. A numerical comparison between two figures is called what? (1 point)
a ratio
a percentage
a sum
a difference
26. When your credit score is poor, your mortgage interest rate will be: (1 point)
Higher
Lower
27. A revolving credit account where the cardholder must pay the full account balance each month is called what? (1 point)
a charge card
a debit card
a credit card
a gift card
28. In a list of numbers placed in numerical order, the middle number is called what? (1 point)
the average
the median
the difference
the total
29. A FREE warranty from an automobile manufacturer that covers any and all mechanical problems for a specified period from the purchase date is generally called what? (1 point)
Supplemental insurance
Bumper-to-Bumper warranty
Manufacturers extended warranty
Sellers guarantee
30. A short-term financial goal is achieved within what time period? (1 point)
10-25 years
1-12 months
1-5 years
30 years
31. E

 
3 Comments

Posted in Uncategorized

 

please pleaseee help with Consumer Math B Final!! I need this grade!! please!!! part 1?

25 May

1. What type of reports do Equifax, TransUnion, and Experian produce?

(1 point)
income studies
credit reports
crime rate statistics
bankruptcy filings
2. How long does a negative notation on your credit report last? (1 point)
one year
ten years
seven years
forever
3. When buying or selling a used car, what’s the best resource on finding an accurate price? (1 point)
Cheryl Red Book
Kelley Blue Book
Paul Pink Book
Newspaper Advertisements
4. If you drive more than 15,000 miles each year, you should lease a car instead of buying one. (1 point)
True
False
5. 401-K’s and IRA’s are examples of what? (1 point)
Debt Consolidators
Stock Markets
Retirement Accounts
Checking Accounts
6. What type of insurance pays you a monthly cash benefit in the event you’re injured and cannot work? (1 point)
Automobile Insurance
Long Term Care Insurance
Disability Insurance
Life Insurance
7. Your annual household income is a part of your credit score calculation. (1 point)
True
False
8. A credit card is an example of what kind of credit: (1 point)
Deferred
Revolving
Interest-Free
Recurring
9. If you have a low credit score, you’ll pay more for insurance. (1 point)
True
False
10. An individual who prefers high risk investments with a (possibly) high-reward is called: (1 point)
Risk-finding
Risk-taking
Risk-seeking
Risk-searching
11. Wealthy people and companies that invest money in startup companies in exchange for a large share of future profits are called what? (1 point)
Venture capitalists
Loan sharks
Loan officers
Risk-averse
12. When someone prefers to invest and participate in the founding of new companies instead of investing in savings instruments or the stock market they would be called what? (1 point)
Risk-averse
Entrepreneurial
Unilateral
Risk-finding
13. What federal program makes sure your bank deposits are never lost due to bank bankruptcy? (1 point)
The Federal Deposit Insurance Corporation
The World Bank
The Securities and Exchange Commission
The Federal Reserve Bank
14. What is the single best way to increase your long-term income? (1 point)
receive a promotion
receive a merit pay increase
increase your educational level
invest in startup companies
15. What is the best way to decrease your expenses? (1 point)
pay down any outstanding credit cards
get a smaller apartment/house
sell your automobile
diversify
16. Which of the following expenses would be considered discretionary expenses? (1 point)
rent
electricity
credit card payments
magazine subscriptions
17. When an asset (something of value) is always connected to the ground and cannot move – it is called what? (1 point)
Liquidated
Real Property
Collateral
Real Estate
18. Expenses such as electricity, telephone service, and water service are called what? (1 point)
Bills
Debt
Utilities
Revolving Credit
19. The money you pay to an insurance company to insure your property or asset is called what? (1 point)
An insurance premium
An insurance deductible
An insurance payment
Insurance coverage
20. When an asset (something of value) such as an automobile or home is voluntarily sold for cash, it would be considered what? (1 point)
Refinanced
Liquidated
Collateral
Repossessed
21. Documentation from an insurance company that states what item or property is insured and the amount that you will receive if the property is destroyed is called what?

(1 point)
An insurance premium
An insurance declaration
An insurance policy
An insurance deductible
22. An Emergency fund should be made up of what? (1 point)
Real property
Savings instruments
Stock
Cash Only
23. The amount of money you’re likely to make in a lifetime is called what? (1 point)
tax bracket
income potential
taxable income
equity
24. When inflation is high, on a daily basis the money in your pocket becomes what? (1 point)
Worth more
Worth less
Liquidated
Discretionary spending
25. A numerical comparison between two figures is called what? (1 point)
a ratio
a percentage
a sum
a difference

 
3 Comments

Posted in Uncategorized

 

neeed help with math problem?

23 May

Need help with math/econ problem…can someone check my work?
jimmy began saving $5,000 a year for her retirement immediately after graduating
college at age 21. he is now 30 as is Procrastinator Paul. Paul begins saving $5,000 a
year at age 30, and continues doing so each year until his retirement at age 65. Smart
jimmy stops adding to her retirement savings after age 30, and simply lets her first 10
years of accumulated savings compound until she retires, like Paul, at age 65.
Assuming each has earned and will continue to earn a 6% rate of return, how large is
each savers nest egg when they reach retirement? [Hint: Assume that n = 36 for the
working years—ages 30 to 65—part of the calculation.]

how do i do this problem using the FV annuity ratio…im so lost

especially for jimmy problem

 
1 Comment

Posted in Uncategorized

 

In the formula for future value (fv = pv (1+i)^t) i am drawing a blank for basic math. why do we need the 1?

22 May

Why do we need the 1? For example: if we have fv = 100,000 (1+6%)^3, we are essentially saying: “The future value of 100,000 with a 6% return after 3 years”. The question is why do we need the 1 to make it 1.06? Why not just make it 100,000 x 6%? What is the rule that requires that 1 to be in the formula. This little basic math question has me curious.

 
1 Comment

Posted in Uncategorized

 

math term help!!! you get 10 points if you can help! need really soon!?

21 May

Which of the following annuity terms best match each of the statements below?

Aannuity due
Bannuity
Cordinary annuity
Dincreasing annuity
Esinking fund
FNone of the above

1.An annuity set up to increase in value over an unspecified number of time periods.
2.An annuity created at the beginning of a period to withdraw funds over equal time periods in the future.
3.An annuity where payments are made at the beginning of the time period.
4.An annuity where payments are made at the end of the time period.
5.An annuity created for a particular amount to be available at a specified future time.
6.A sequence of equal payments made at equal time periods.

 
1 Comment

Posted in Uncategorized

 

Math homework – find the present value?

21 May

First, the bond pays 110+6t per year for 10 years. Second, the interest rate is 3.5% compounded continuously. Round your answer to the nearest cent.

Present Value =

Please provide the steps that you did to get to your answer. By the way, I have a TI-83 graphing calculator and I believe that this equation involves using the fnint( function.

 
1 Comment

Posted in Uncategorized

 

Annuity math question!?

19 May

Problem: Find the monthly payment on a 100,000$, 25-year mortgage at 12% interest compounded monthly.

I do these on my calculator (T-83 plus)

What I have so far:
FV- 100,000
PMT- (to be solved)
PV- 0
N and i I cannot find…. How do I find N and i?

I do not understand what interest compounded monthly means. Someone please tell me. Thanks

 
1 Comment

Posted in Uncategorized

 

Here is the question that i need answered it has to do with math ?

08 May

5. Calculating Earnings on Savings. What would be the yearly earnings for a person with $6,000 in savings at an annual interest
rate of 5.5 percent?

6. Computing the Time Value of Money. Using time value of money tables, calculate the following. (Obj. 4)
a. The future value of $450 six years from now at 7 percent.
b. The future value of $800 saved each year for 10 years at 8 percent.
c. The amount a person would have to deposit today (present value) at a 6 percent interest rate to have $1,000 five years
from now.
d. The amount a person would have to deposit today to be able to take out $500 a year for 10 years from an account earning
8 percent
If any one can help me with this question that would be great…
I need to show all work so if you can show me how you did it that would be great thank you….

 
4 Comments

Posted in Uncategorized

 

Help with math problems?

06 May

Find the future value of annuity due. How much from contributions and how much from interest

1. $750 deposited at the beginning of the month for 15yrs at 5.9% compounded monthly

2. $250 deposited at the beginning of each quater for 12yrs at 4.2% compounded quarterly

 
1 Comment

Posted in Uncategorized

 

Topic in Math of Investment (Annuity): How will know if the question is asking for the maturity or present val

04 May

Also… how will I know if that is ordinary or due after finding out that it’s a maturity or present value problem?

 
1 Comment

Posted in Uncategorized