Roster Pte Ltd issued 100 million of 11-year bonds with a 9.5% coupon payable annually. This bond was issued a year ago. The first coupon payment has just been paid. The bonds are callable at 105 beginning today. Floatation costs on that issue were $1 million. Roster pte has 38% marginal tax rate. Roster Pte is planning to call the bonds and refinance at current rates. The following 10 years alternatives exist: (show all calculations)

a. 100 million public issue of 8% annual coupon bonds. Floatation costs would be one million.

b. 100 million private placement with 8% semi-annual coupons with a placement fee of 500000.

(Call premiums and interest payments are tax deductible but the frontend fee and floatation cost must be capitalized and amortized over the life of the bond.)

1. What will be the effective cost of raising funds from the public bond issue using IRR ?

2. Effective cost of raising funds from private placement of debt.?

3. If the bonds are called, which of two refinancing options is more preferable and why?

4. What's the effective after-tax cost of refinancing that would make Roster Pte indifferent calling the bonds and leaving them as it is?

5. Should the bonds be called in? why or why not?

Halo Inc. manufactures several different products including product A and product B. Halo uses activity-based costing, such that the total manufacturing overhead for the month, of $750,000, is assigned to the following cost pools with the corresponding activity levels:

The following information for products A and B for the current month is available:

a. If Halo were to use a single, predetermined overhead rate of $40 per labor hour, how much would each product cost?

b. Using activity-based costing, how much does each product cost?

c. If there is a difference between your answers to (a) and (b), why is this? And what costs are driving the difference?

d. Which answer (a) or (b) should Halo use in decision-making? And why is it better for decision-making?

e. So, based upon your answers to (d), which product is most profitable?

f. What might the managers do to increase the profits of Halo? What should they focus on first?

Nanuq has a women’s fashion store Larmington. The manager of this store is trying to decide how many Jill Cladess dresses to order for this summer season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100 dresses. The contract for the purchase and delivery of dresses between Larmington and Cladess is as follows: At the beginning of October, manager of Larmington reserves Ұ dresses, called as capacity Ұ by both parties. Larmington must take delivery for at least 0.8 Ұ dresses and can, if desired, take delivery on up to its reserved capacity of Ұ dresses. Each dress sells for $160 and Cladess charges $70 per dress. If Larmington does not take delivery of all Ұ dresses they reserved, it owes Cladess a $12 penalty for each unit of reserved capacity that is unused (not delivered to store). Use Ұ as 400 first to calculate the profit to Larmington store.

Work out the average profit due to 100 simulations. Make sure to round off the demand, delivery, sale amounts, revenue, cost and penalty using ‘ROUND’ function in Excel

Now repeat the 100 simulations for each capacity of 450, 500 and 550.

Based on the above four reserved amounts, decide how many dresses Larmington should reserve (value of Ұ) to maximise its profit for the season. Justify your answer.

Use Visual Basic Language

In this assignment you will need to create a program that will have both a “for statement” and an “if statement”. Your program will read 2 numbers from the input screen and it will determine which is the larger of the 2 numbers. It will do this 10 times. It will also keep track of both the largest and smallest numbers throughout the entire 10 times through the loop. An example of the program would be the first time through the loop; you input the number 10 and 50. The program would respond with 50 being the larger of the two. You next would input 100 and 75. The program would then respond with 100 being the larger of the two. Upon the 10th time through the loop the program would determine not only which number is the largest but also what was the largest number in the session and which was the smallest number in the session. In this example we only did two loops through the session but the correct answer at this point would be the largest number as 100 and the smallest as 10.

A few hints...

• Create variable

o Num1

o Num2

o Lownum

o Highnum

For loop will be 1 to 10

• If statements

If num1 > num2 then

Console.writeline(“Number 1 is larger ” & Num1)

o Else Console.writeline(“Number 2 is larger ” & Num2)

o End if

If statement to check high and low

If num1 > highnum then

Highnum = num1

o End if

If num1 < lownum then

Lownum = numn1

o End if

o Don’t forget num2

I have this program in C that takes three char arrays that each have a first and last name. I have two functions that reverese the name and change it to all upper case. I have the program completeed but need to change both functions to use pointers instead of arrays. I will bold the functions I need to use pointers.

#include <stdio.h>

void upper_string(char []);

int main()
{
char name1[100]="John Smith";
char name2[100]="Mary Cohen";
char name3[100]="Carl Williams";
upper_string(name1);// calling upper case function
upper_string(name2);
upper_string(name3);
printf("Names are in upper case \n\"%s\"\n""%s\"\n""%s\"\n", name1,name2,name3);
reverse(name1);// calling reverse string function
reverse(name2);
reverse(name3);
  
getch();
}

void upper_string(char s[]) {
int c = 0;

while (s[c] != '\0') {
if (s[c] >= 'a' && s[c] <= 'z') {
s[c] = s[c] - 32;
}
c++;
}
}
// function to reverse the string
void reverse(char string[]){

char temp;
int i, j = 0;
i = 0;
j = strlen(string) - 1;

while (i < j) {
temp = string[i];
string[i] = string[j];
string[j] = temp;
i++;
j--;
}

printf("\nReverse string is :%s", string);
}

Donald loves gambling. His favorite gambling activity is going to the horse tracks and betting on his favorite horse, Betty. Donald's weekly income is $100, which he takes to the tracks. Donald can only purchase $50 lottery tickets on Betty finishing 1st. Betty's probability of winning each race is .5 and in case of a victory Donald gets $100 per every ticket bought while he gets nothing when Betty doesn’t end up in the first place. 1. Suppose that Donald can only bet multiples of $50. Calculate the expected value of buying (i) no tickets, (ii) 1 ticket, and (iii) 2 tickets. Don’t forget to take into account that he has an initial wealth of $100. Is the reward of any of the options more worthy than the other? 2. Donald's utility function is u(x) = x 2 . Find his expected utility from buying (i) no tickets, (ii) 1 ticket, and (iii) 2 tickets. How many tickets will he buy? 3. Suppose Donald’s family wants to stop him from going to the horse tracks. They want to design a conditional cash transfer program in which Donald receives a weekly allowance with the condition of not going to the horse tracks. How much should this allowance be to convince Donald not to buy 2 tickets each week?

Q. In java, I would like to know, especially how the program detect there is an error which is user should put only numerical data but if user put letter data (five, sixty instead of 5,60), *I want the program display "Invalid data. Please try again" instead of long error message(from the IDE)* when user put letter data(five, sixty stuff...) and GO BACK TO THE BEGINNING SO USER CAN PUT THE DATA AGAIN!

Write a program that counts change. The program should ask for the number of quarters, the number of dimes, the number of nickels and the number of pennies. The program should then compute the value of all the coins and tell the user how much money there is, expressed in dollars. Display a title at the top of the screen when the program first runs. You must use constants for the value of each coin type. Multiply the number of each coin times the value for each coin (the defined constant). Refer to the PowerPoint or video on the use of the constants.

1) if quarters =100 dimes = 100 nickels = 100 pennies = 99

=>expected result = 40.99

2) if quarters = hundred dimes = hundred nickels = nine pennies = hundred

=> expected result ""Invalid data. Please try again" (GO BACK TO THE BEGINNING, SO USER CAN PUT THE DATA AGAIN!) <- this is the part i am struggling. Please Help!

You are in charge of the department that receives the product in to the building and stows it to the bin where it is accessible by the department. you have two options on how to receive and stow the product. In the first option, you receive the product at 250 units per labor hour and stow it at 100 units per labor hour. You must receive it and stow it for the unit to count for production. This process results in 1% of the units stowed being incorrect. You can find and fix these errors at a rate of 20 units for labor hour with what you believe is almost 100% accuracy. In the second option, you receive and stow the product in one step vs. two. The rate for this process is 80 units per labor hours for receive and stow. This process results in 1.5% of the units being stowed being incorrect. You can find and fix these errors at a rate of 20 units per hour with what you believe is almost 100% accuracy. 1. Which option would you select to process today's units and why? 2. Does your answer change if you are told you must fully process 100,000 units today? If yes, why? 3. Does your answer change if you are told that you have 15 associates today and you must fully produce the maximum amount of units possible? If yes, why?

Look at the following demand and supply schedules for the new Pepsi product just being introduced. We will assume that the units are case lots bought by an individual family within the first six months of introduction.

1.    If the price of Crystal Pepsi were $2.00 per case, how many cases would be offered for sale?       

2.    If the price of Crystal Pepsi were $2.00 per case, how many cases would people be willing to buy?           

3.    How many cases would actually be traded (go through the market) if the price were left at this $2.00 level?                     

4.    Would this constitute a surplus or a shortage?                           

5.    How much of a surplus or shortage would there be?                         

6.    If the market process were allowed to work, what would you expect to happen to the price of Crystal Pepsi?                     

7.    If the price of Crystal Pepsi rose to $8.00 per case, how many cases would be offered for sale?     

8.    If the price of Crystal Pepsi rose to $8.00 per case, how many cases would be demanded by families.     

9.    If the price remained at $8.00 per case, how many cases would actually be traded (go through the market)                     

10.    Would this constitute a surplus or a shortage?                           

11.    How much of a surplus or shortage would there be?                       

12.    If the market process were allowed to work, what would you expect to happen to the price of Crystal Pepsi?                    

Create three MySQL database tables and write SQL scripts to read, insert, and delete data. The first database table will contain the names of at least four movies. The second table will be a list of actors who appear in the movies. The third table will be an associative table that describes the relationship between the actors and their movies (which actors appear in which movies). Actors and movies have a “many-to-many relationship,” meaning an actor can be in multiple movies and a movie can have multiple actors.

• Use the MySQL Database Instructions listed below to create the three tables.
• Once the three tables are completed, create a “join” statement that joins data from all three tables. Remember that field names used in more than one table (ASIN, ActorID) must be fully qualified (i.e., dvdtitle, ASIN).
• The previous SQL query returns a separate record for each actor. Provide a way to group results from several records into a single row.

General guidelines for this:

• String values in SQL statements are always enclosed within single quotes. ASIN and Title are both strings and require single quotes. For instance, your insert statement will look something like this:
  $sql = “Insert into dvdtitles (asin, title, price) VALUES (‘$asin’, ‘$title’, $price)”;
• SQL debugging tip: check your SQL statement before you execute it. Put the following line of code immediately before the mysql_query($strSQL) statement.
• When retrieving ASIN from the querystring, remember that ASIN is a string, not a number.
• Explain in detail (like im 5) the process on how to group results from several records into a single row.

Table 1

1. Create a MySQL database table named “tbldvdtitles.” You will be adding information about a minimum of four of your favorite movies.

The table should have the following structure:

2. Write a SQL statement to add the ASIN, price, and title for your favorite movies.

Table 2

1. Create a second database table named “tbldvdActors.” Your table should have the following structure:

2. Write a SQL statement to add at least four actors, one from each of your listed movies.

3. Write a SQL statement to update the last actor fname, and lname information.

4. Write a SQL statement to delete the first actor in the tbldvdActors table.

Table 3

1. Create a third database table of relationships between actors and movie titles. The table should have the following structure:

1. (Because this table uses a composite key, the delete statement must reference both the asin and actorID fields.)

2. Add data that describes the relationship between your movies and actors.