by using Excel, please do the attached document project. follow all the steps in the attached document. the project must only contain the steps and the statictic numbers in the attached document (Ballwin police dept page#1, police municipality page#5, which they are in the attached document).

 

***Don’t bring anything out of the attached document, and don’t add stuff on your own. 

** please, follow everything in the attached document ((Ballwin police dept page#1, police municipality page#5, which they are in the attached document)).. and don’t bring anything else or add things. 

Within the Discussion Board area, write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.

 

The Southwest regional manager is having trouble preparing a bid for a lucrative government contract to supply blenders to the military dining facilities in Fort Hood, Texas. Specifically, he has asked for your assistance as he determines his approach to pricing.

Complete the following:

• Define and describe cost-based pricing.
• Define and describe market-based pricing.

In addition, the government contract officer mentioned the requirement to present a fair and reasonable price to be considered for the contract. Identify the guideline or regulation that governs acquisition and contracting, and describe the concept of fair and reasonable price in government contracts.

Were the Populist and pro-silver movements of the 1800s and 1890s essentially backward-looking protests by a passing rural America, or were they, despite their immediate political failure, genuine prophetic voices raising central critical questions about democracy and economic justice in the new corporate industrial America

BU340 Financial Management I

Directions:  Be sure to save an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to use correct English, spelling, and grammar.

 

Respond to the items below.

 

Part A:Given the following cash inflow at the end of each year, what is the future value of this cash flow at 6%, 9%, and 15% interest rates at the end of the seventh year?

 

Year 1                             $15,000

Year 2                             $20,000

Year 3                             $30,000

Years 4 through 6                   $0

Year 7                          $150,000

 

Part B: County Ranch Insurance Company wants to offer a guaranteed annuity in units of $500, payable at the end of each year for 25 years. The company has a strong investment record and can consistently earn 7% on its investments after taxes. If the company wants to make 1% on this contract, what price should it set on it? Use 6% as the discount rate. Assume that it is an ordinary annuity and that the price is the same as present value.

 

Part C: A local government is about to run a lottery but doesnot want to be involved in the payoff if a winner picks an annuity payoff. The government contracts with a trust to pay the lump-sum payout to the trust and have the trust (probably a local bank) pay the annual payments. The first winner of the lottery chooses the annuity and will receive $150,000 a year for the next 25 years. The local government will give the trust $2,000,000 to pay for this annuity. What investment rate must the trust earn to break even on this arrangement?

 

Part D: Your dreams of becoming rich have just come true. You have won the State of Tranquility’s Lottery. The State offers you two payment plans for the $5,000,000 advertised jackpot. You can take annual payments of $250,000 for the next 20 years or $2,867,480 today.

 

a.      If your investment rate over the next 20 years is 8%, which payoff will you choose?

 

b.     If your investment rate over the next 20 years is 5%, which payoff will you choose?

 

 

c.      At what investment rate will the annuity stream of $250,000 be the same as the lump sum payment of $2,867,480?