PYTHON PROGRAM

Buzz Lightyear is teaching his friends about money. At the moment, they are using fictional $ 5, 10, and 20 Monopoly game bills. Buzz hands out the bills to his friends so that they each have the same amount of money. Then he moves the bills from one friend's pile and puts it on another's pile. Next, the toys have to figure out which one has more money and which one has less.
Sometimes Buzz doesn't move a bill so everyone has exactly the same amount of money; toys should know when this happens.

Input Format:
The first line of each scenario consists of a positive integer, N, which represents the number of toys (2 <N <= 100). Each of the next N lines contains the data for a toy. The lines contain four items, the name of the toy (a single series of 2-10 letters, lowercase except the first) followed by the number of $ 5, 10, and 20 bills (in that order) assigned to that toy. The elements are separated by single spaces. The input ends in a scenario where N equals -1. This scenario should not be processed.

Constraints:
toys (2 <N <= 100)

Output Format:
The output consists of one line for each scenario. It will be in one of the following two formats:

X has more money, Z has less money.
They all have the same amount.
X and Z are names of toys.

EXCEL VBA

1. ABC company gives discount as follows:
   Purchase > $400                                                                     Discount rate = 5%
   Purchase between $300 and $400                                          Discount rate = 4%
   Purchase >= $100 and < $300                                              Discount rate = 2%
   Purchase < 100                                                                       No discount
   Purchase = Price * Quantity
   Discount = Purchase * Discount rate                                    
   Net Purchase = Purchase – Discount

Total Net Purchase is the running total of Net Purchases

Create a user interface form as shown below. Use text boxes to input price and quantity. Use labels to display the discount, net purchase (purchase amount after discount) and total net purchases. Click calculate button to calculate and display discount, net purchase, and total net purchases; click clear button to clear values from the text boxes and labels, except total net purchases; send the focus to the price text box.
Click exit button to end the application.

2. Create a sub procedure in a module to calculate:
   a) the sum of even integers from 4 to 12 using DO WHILE. Display the sum in the message box. Name the sub procedure as Q2a.
   b) the sum of odd integers from 5 to 9 using FOR NEXT. Display the sum in message box. Name the sub procedure as Q2b.
   
3. Create a sub procedure named as Question3 in a module to calculate the value and total value of items using a Do/while Loop. Value = Price * Quantity. Total value is the running total of values. Use INPUTBOX function to get the price and quantity. Display the value in the message box. Display total value in the message box after exiting the loop. Loop is entered by inputting “Y” at the prompt “Do you wish to continue?” and exited by entering “N” at the prompt “Do you wish to continue?”
   
4. Create a sub procedure named as Question4 in a module to find the capital. Use INPUTBOX function to get the state and message box function to display the capital.

State                Capital

MN                   St.Paul

WI                   Madison

TX                   Austin

1.A stock is currently trading for $35. The company has a price–earnings multiple of 10. There are 100 million shares outstanding. Your model indicates that the stock is actually worth $40. The company announces that it will use $340 million to repurchase shares.

1. After the repurchase, what is the value of the stock, according to your model? Do not round intermediate calculations. Round your answer to the nearest cent.

   $  

2. After the repurchase, what is the actual price–earnings multiple of the stock? Do not round intermediate calculations. Round your answer to two decimal places.

3. If the company had used the $340 million to pay a cash dividend instead of doing a repurchase, how would the value of the stock have changed, according to your model? Do not round intermediate calculations. Round your answer to the nearest cent.

   The market value of the stock is now $   .

2.A stock is currently trading for $33. The company has a price–earnings multiple of 10. There are 100 million shares outstanding. Your model indicates that the stock is actually worth $28. The company announces that it will use $350 million to repurchase shares.

1. After the repurchase, what is the value of the stock, according to your model? Do not round intermediate calculations. Round your answer to the nearest cent.

   $  

2. After the repurchase, what is the actual price–earnings multiple of the stock? Do not round intermediate calculations. Round your answer to two decimal places.

3. If the company had used the $350 million to pay a cash dividend instead of doing a repurchase, how would the value of the stock have changed, according to your model? Do not round intermediate calculations. Round your answer to the nearest cent.

   The market value of the stock is now $   .

4. If the company had used the $350 million to pay a cash dividend instead of doing a repurchase, what would be the actual price–earnings multiple after the dividend? Do not round intermediate calculations. Round your answer to two decimal places.

(TCO 5) You have been accepted into a prestigious private university in Illinois for your doctoral program. Congratulations! Since no one from this school has ever graduated in only 4 years, you anticipate that you will need to make 11 semi-annual tuition payments of $35,000 each with the first cash flow 6 months from today. If you choose to discount these cash flows at an annual rate of 8%, what is the present value cost of tuition to attend your university of choice? (TCO 5) You are about to purchase a new car from a dealer who has a new and unusual payment plan. You have the choice to pay $29,000 cash today or $32,000 in 4 years. If you have the opportunity to borrow the cash price value of the car at a rate of 3.0% and repay the loan in a lump sum in 4 years, which option should you take and why? (TCO 5) Which choice has a greater present value if we assume a required rate of return of 8%? (1) A lump-sum cash flow today of $248.69 (2) $100 cash flows occurring 1, 2, and 3 years from today (3) A single cash flow of $331 3 years from today

1. Financial institutions in the U.S. economy

Suppose Paolo would like to invest $2,000 of his savings.

One way of investing is to purchase stock or bonds from a private company.

Suppose TouchTech, a hand-held computing firm, is selling stocks to raise money for a new lab—a practice known as _____ (equity or debt) finance. Buying a share of TouchTech stock would give Paolo _________ (a claim to partial ownership in/ an IOU, or promise to pay, from) the firm. In the event that TouchTech runs into financial difficulty, _______ (The bondholders/ Paolo and other stockholders) will be paid first.

Suppose Paolo decides to buy 100 shares of TouchTech stock.

Which of the following statements are correct? Check all that apply.

The price of his shares will rise if TouchTech issues additional shares of stock.

The Dow Jones Industrial Average is an example of a stock exchange where he can purchase TouchTech stock.

Expectations of a recession that will reduce economy-wide corporate profits will likely cause the value of Paolo's shares to decline.

Alternatively, Paolo could invest by purchasing bonds issued by the U.S. government.

Assuming that everything else is equal, a corporate bond issued by an electronics manufacturer most likely pays a ____ (lower/higher) interest rate than a municipal bond issued by a state.

1. Financial institutions in the U.S. economy

Suppose Rajiv would like to invest $4,000 of his savings.

One way of investing is to purchase stock or bonds from a private company.

Suppose RoboTroid, a robotics firm, is selling stocks to raise money for a new lab—a practice known as (equity/debt) finance. Buying a share of RoboTroid stock would give Rajiv ( an IOU, or promise to pay,from/a claim to partial ownership in)   the firm. In the event that RoboTroid runs into financial difficulty,( Rajiv and the other stockholders/the bondholders) will be paid first.

Suppose Rajiv decides to buy 100 shares of RoboTroid stock.

Which of the following statements are correct? Check all that apply.

1.The Dow Jones Industrial Average is an example of a stock exchange where he can purchase RoboTroid stock.

2.Expectations of a recession that will reduce economy-wide corporate profits will likely cause the value of Rajiv's shares to decline.

3.The price of his shares will rise if RoboTroid issues additional shares of stock.

Alternatively, Rajiv could invest by purchasing bonds issued by the government of Japan.

Assuming that everything else is equal, a bond issued by the government of Japan most likely pays a (higher/lower)    interest rate than a bond issued by a government that is engaged in a civil war.

1. Alpha Ltd has appointed you as a manager in the budgeting department. The company has provided the following information to prepare a cash flow budget for the six months from the 1 January 2021 to 30 June 2021.

1. Alpha Ltd produces only one type of product and the projected selling price of the product is £2 for January and February and after that will be fixed at £3 for the foreseeable future.    
2. For the first three months of the year, 2,000 units will be sold per month. For the following three months, 2,500 units will be sold per month. Sales income is to be received in the month of sale.
3. Insurance costs are £200 every two months. The company will pay for insurance on 1 December 2020.
4. The company is paying 20% of sales of each month as bonus to the employees in the following month. The total sales during December 2020 will be £5,000.
5. Alpha Ltd will pay overhead costs of £2,000 each month.
6. The opening cash balance at 1 January 2021 will be £1,000.
7. The monthly cost of direct material and direct labour is estimated to be £500 and the company will pay them during each month.
8. Fixed costs of production are £100 per month, payable in the month.

1. Prepare a cash flow budget for the period 1 January 2021 to 30 June 2021 and indicate the closing balance as at 30 June 2021.

Bramble Corp. was organized on January 1, 2019. It is authorized to issue 13,000 shares of 8%, $100 par value preferred stock, and 526,000 shares of no-par common stock with a stated value of $3 per share. The following stock transactions were completed during the first year:

Post to the stockholders’ equity accounts. (Post entries in the order of journal entries presented in the previous part.)