Question

In: Finance

Answers are provided but need step by step solutions without excel just basic step by step...

Answers are provided but need step by step solutions without excel just basic step by step with formulas

1. John invested $20,000 fifteen years ago with an insurance company that has paid him 8 percent (APR), compounded quarterly (every 3 months). How much interest did John earn over the 15 years?= $45,620.62

2. You are running short of cash and really need to pay your tuition. A friend suggests that you check out the local title pawn shop. At the shop they offer to loan you $5,000 if you pay them back $6,000 in one month. It seems like a good idea to you because you don’t want to sell your car and you are sure you will be able to pay the money back in a month. What is the APR on this loan?=. 240%

4. You want to buy a new sports car for $50,000. The contract is in the form of a 60-month annuity due at a 7.2 APR. What will your monthly payment be?= $988.85

6. The stated rate (APR) is 8.6% with semi-annual compounding. What is the equivalent annual rate (EAR)?= 8.78%

7. The effective annual rate (EAR) is 9% with monthly compounding. What is the stated rate (APR)?= 8.649%

8. Ryan delivers newspapers and is putting $40 in the bank at the end of each quarter. Ryan is 10 years old and will use the money when he goes to college in 8 years. What will be the value of Ryan’s account in 8 years if he is earning 8.5% APR with quarterly compounding?=$1,806.81

11. Tim needs to borrow $5,000 for two years. The loan (principal and interest) will be repaid in one lump sum at the end of the loan term. Which one of the following interest rates is best for Tim? = 7.2 percent simple interest

12. You want to invest an amount of money today and receive back twice that amount in the future. You expect to earn 8.6 percent interest. How long must you wait for your investment to double in value? = 8.4 years

13. Taylor has just received an insurance settlement of $58,400. She wants to save this money until her oldest daughter goes to college. Taylor can earn an average of 5.5 percent, compounded annually, on this money. How much will she have saved for her daughter's college education if her daughter enters college 14 years from now? = $123,579.74

14. Your grandfather gave you a 50 cent piece his father got in 1922. Today (2010) the coin is worth $2,000. What is the return on this investment? = 9.884 percent

16. When you were born, your aunt opened an investment account in your name and deposited $500 into the account. You are now 22 years old. Today, the account is valued at $6,492.74.. Assuming semi-annual compounding, what is the average annual rate of return on the account?=12%

19. William’s landscaping needs to borrow $42,000 for a new front-end loader. The bank is willing to loan the funds at 10% interest with annual payments at the end of the year for the next 10 years. What is the annual payment?= $6,835.30

20. You are delinquent on one of your credit cards. You have agreed with the bank to make payments of $90 per month starting the end of this month. The interest rate on the balance is 1% per month. If you owe $8,000, how long will it take for the account to be paid off?= 221 months

Part 2: Problems.

1. You have compiled the following information for a firm:

2008 2009

Sales $7,487 $9,618

Interest paid 735 785

Cost of goods sold 2,713 3,284

Other costs 592 728

Current assets 3,131 3,383

Current liabilities 564 643

Net fixed assets 8,592 7,517

Long-term debt 1,455 1,698

Dividends paid 120 100

Depreciation 202 263

year 2009. The tax rate is 35%.

  1. What was net income (NI)?

  2. What was operating cash flow (OCF)?

  3. What was net capital spending (NCS)?

  4. What was the change in net working capital (ΔNWC)?

  5. What was the cash flow from assets (CFA)?

Solutions

Expert Solution

Since, multiple questions have been posted, I have answered the first four.

______

Question 1:

The value of interest can be derived with the use of following equation:

Interest = Amount Invested*(1+Rate of Interest/Compounding Frequency)^(Years*Compounding Frequency) - Amount Invested

Here, Amount Invested = $20,000, Rate of Interest = 8%, Compounding Frequency = 12/3 = 4 and Years = 15

Substituting values in the above formula, we get,

Interest = 20,000*(1+8%/4)^(15*4) - 20,000 = $45,620.62 (answer)

_____

Question 2:

The value of APR can be derived as below:

APR = (Interest Amount/Loan Amount)*12*100

Here, Interest Amount = 6,000 - 5,000 = $1,000 and Loan Amount = $5,000

Substituting values in the above formula, we get,

APR = (1,000/5,000)*12*100 = 240% (answer)

_____

Question 4:

The amount of monthly payment can be arrived with the use of formula given below:

Payment = [Rate*(Present Value)/(1-(1+Rate)^(-Periods))]*1/(1+Rate)

Here, Rate = 7.2%/12 = .60%, Present Value = $50,000 and Periods = 60

Substituting values in the above formula, we get,

Payment (Monthly) = [.60%*(50,000)/(1-(1+.60%)^(-60))]*1/(1+.60%) = $988.85 (answer)

_____

Question 6:

The equivalent annual rate can be calculated with the use of following formula:

Equivalent Annual Rate = (1+APR/Compounding Frequency)^(Compounding Frequency) - 1

Here, APR = 8.6% and Compounding Frequency = 2

Substituting values in the above formula, we get,

Equivalent Annual Rate = (1+8.6%/2)^2 - 1 = 8.78% (answer)


Related Solutions

I NEED STEP BY STEP SOLUTIONS FOR EACH PART. DO NOT SKIP ANY PART. ANSWERS TO...
I NEED STEP BY STEP SOLUTIONS FOR EACH PART. DO NOT SKIP ANY PART. ANSWERS TO EACH ARE MARKED IN BOLD 18. Determine the market value of a “comparable” firm based on the following information: value of target firm = $4,000,000; net income of target firm = $200,000; and net income of “comparable” firm = $500,000.                         a.   $4 million                         b.   $7.5 million                         c.   $10 million                         d.   $12.5 million                         e.   $15 million 19. Determine the net...
The answers previously provided are all over the place. Without Excel Please. - - Your sister...
The answers previously provided are all over the place. Without Excel Please. - - Your sister has estimated that the maintenance costs on the “slightly used” car she just purchased will be $500 in the first year. She anticipates that this cost will increase by $150 each year. She wants to set aside enough money today to cover all anticipated maintenance costs for the 10 years that she plans to own the car. How much should she deposit today in...
I DID STEP 1-2 AND 3 I JUST NEED A STEP 4 ANSWERS AND THIS IS...
I DID STEP 1-2 AND 3 I JUST NEED A STEP 4 ANSWERS AND THIS IS SO EMERGENCY(DUE DATE TONIGHT) PLEASE HELP (I WILL GIVE UPVOTE AND GOOD COMMENT THANK YOU) if you need to see step 1-2-3 I can add on the comment. Step 1 - WhoIs Step 2 - TCP Port Scanning Step 3 - UDP Port Scanning Step 4 - Analysis ---- Answer these questions: How can this type of scanning be used to help a network...
Step by step with provided answers. What is the formula step by step? Thank you so...
Step by step with provided answers. What is the formula step by step? Thank you so much. 10. Given annual returns of 14%, 8%, -10% and 4%, what is the geometric average?             = 3.61%             11. What is the arithmetic average of the returns in question 10?             = 4.00%             12. What is the standard deviation of the returns in question 10?             = 10.20%             16. Moi International wants to issue 20-year, zero coupon bonds that yield...
I know the answers I just need detailed step-by-step instructions. Brad Company developed the following budgeted...
I know the answers I just need detailed step-by-step instructions. Brad Company developed the following budgeted life-cycle income statement for two proposed products. Each product's life cycle is expected to be two years. Product A Product B Total Sales $200,000 $200,000 $400,000 Cost of goods sold 120,000 130,000 250,000 Gross profit $ 80,000 $ 70,000 $150,000 Period expenses:      Research and development (70,000)      Marketing (50,000) Life-cycle income $ 30,000 A 10 percent return on sales is required for new products. Because...
Need step by step solutions and calculations The following is a set of data from a...
Need step by step solutions and calculations The following is a set of data from a sample of 11 items X: 7 5 8 3 6 0 2 4 9 5 8 Y: 1 5 4 9 8 0 6 2 7 5 4 a. Construct a scatter plot using the sample data. b. Calculate the mean, median variance and coefficient of variation and z-scores for X. c. Determine the outliers. d. Determine the quartiles of X. e. Construct a...
I need a step by step for entering in excel. For this assignment, your group will...
I need a step by step for entering in excel. For this assignment, your group will utilize the preliminary data collected in the Topic 2 assignment. Considering the specific requirements of your scenario, complete the following steps using Excel. The accuracy of formulas and calculations will be assessed. Select the appropriate discrete probability distribution. If using a binomial distribution, use the constant probability from the collected data and assume a fixed number of events of 20. If using a Poisson...
I need step by step instructions on using Excel to do this assignment and the values...
I need step by step instructions on using Excel to do this assignment and the values I need to enter to compute what is being asked of me. I don't know how to use Excel and you tube is no help right now because I can't find specifics of what I need done. I'll post part two of this assignment as a seperate question. I need to get through part one first. Thanks... 1. Exercise 11   Section 3-1 11. Weight...
I need Urgent on the correct way to solve this, step by step process. The answers...
I need Urgent on the correct way to solve this, step by step process. The answers are 7.62, 7.62,6.92,20% and 7.41. Please HELP!!! Hula Enterprises is considering a new project to produce solar water heaters. The finance manager wishes to find an appropriate risk adjusted discount rate for the project. The (equity) beta of Hot Water, a firm currently producing solar water heaters, is 1.1. Hot Water has a debt to total value ratio of 0.3. The expected return on...
Please solve all answers on Excel and show step by step how you get the WACC...
Please solve all answers on Excel and show step by step how you get the WACC answer.   Tornado Motors is a major producer of sport and utility trucks. It is a family owned company, started by Jane Biscayne in 1935, at the height of the Great Depression. Today the firm produces 3 lines of trucks. These include a standard, no-frills short bed pickup truck (Model A), a mid-size version (Model B ) and a larger, heavy-duty work truck (Model C)....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT