Ask Experts Questions for FREE Help!
 

Free Answers in 3 Easy Steps

Register Now
3 Steps
 


Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.
  Answer this Question    Ask about Finance & Accounting    Ask about another Subject  
 

nicole18765
May 10, 2008, 02:53 PM
I have a question on some homework I just finished.

I was provided w/ the following information:
Assume it is January 31, 2008
company wishes to make following improvements at the listed costs
Build new headquaters in 6 years $3,000,000.00
Purchase new supplies for headquaters in 6 years $1,500,000.00
Expand current operations in domestic maket in 10 years $10,000,000.00
Expand current operations in foreign market in 4 years $25,000,000.00

Additional Financial Info
ADDITIONAL FINANCIAL INFORMATION

SALES 63,000,000.00
COGS 42,000,000.00
WAGES 6,000,000.00
UTILITIES 2,000,000.00
BUILDING EXPENSES 4,500,000.00
OTHER EXPENSES 685,000.00

I prepared an income statement to determine net income and came up with 7,815,000.00
I was also provided with the following info
Retained Earning as of 1/1/2008 $18,000,000.00

Which I believe gives me cash on hand at 25,815,000.00

My Board wants me to determine if there is enough money to purchase bonds today at a 10% return rate in order to accomplish these plans.

I did the following:
I would need to purchase 20,000,000.00 worth of bonds
I currently have 25,815,000.00 so I do have enough money to purchase bonds now.

I would think that I would also need to know how much interest I am going to receive a year in order to accomplish the goals
in the time frames mentioned above.

20,000,000.00 *10%
Year 1 2,000,000.00 22,000,000.00
Year 2 2,000,000.00 24,000,000.00
Year 3 2,000,000.00 26,000,000.00
Year 4 2,000,000.00 28,000,000.00
Year 5 2,000,000.00 30,000,000.00
Year 6 2,000,000.00 32,000,000.00
Year 7 2,000,000.00 34,000,000.00
Year 8 2,000,000.00 36,000,000.00
Year 9 2,000,000.00 38,000,000.00
Year 10 2,000,000.00 40,000,000.00
I do not think the company has the money to go ahead with its expansion plans because if I am thinking right, I would need to pay 20,000,000.00 up front for the bonds, and then would only receive interest in an annual payment and payment for the face value of the bond when the bond comes due.

I am confused on this because I am not sure if I should be using an present value table for determing the amount of money I would need to invest today to make 39,500,000.00 in ten years.