Raintree Cosmetic Company sells its products to customers on a credit basis. An adjusting entry for bad debt expense is recorded only at December 31, the company’s fiscal year-end. The 2017 balance sheet disclosed the following: Current assets: Receivables, net of allowance for uncollectible accounts of $30,000 $432,000 During 2018, credit sales were $1,750,000, cash collections from customers $1,830,000, and $35,000 in accounts receivable were written off. In addition, $3,000 was collected from a customer whose account was written off in 2017.

An aging of accounts receivable at December 31, 2018, reveals the following: Percentage of Year-End Percent Age Group Receivables in Group Uncollectible

0–60 days 65 % 4 %

61–90 days 20% 15%

91–120 days 10% 25%

Over 120 days 5% 40%

Required:

1. Prepare summary journal entries to account for the 2018 write-offs and the collection of the receivable previously written off.

2. Prepare the year-end adjusting entry for bad debts according to each of the following situations: Bad debt expense is estimated to be 3% of credit sales for the year. Bad debt expense is estimated by computing net realizable value of the receivables. The allowance for uncollectible accounts is estimated to be 10% of the year-end balance in accounts receivable. Bad debt expense is estimated by computing net realizable value of the receivables. The allowance for uncollectible accounts is determined by an aging of accounts receivable.

3. For situations (a)–(c) in requirement 2 above, what would be the net amount of accounts receivable reported in the 2018 balance sheet?

The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit (in $) from each plant to each warehouse are shown below along with customer demand and shipping costs per unit (in $) from each warehouse to each customer

Formulate the linear programming model to minimize the cost of shipping for this transshipment problem.

A-at the optimal solution how much is shipped from Plant 3 to Warehouse 1?

B-what is the range of optimality of coefficient of cost from Plant 3 to Warehouse 1 and what does this mean?

C-what is the range of feasibility for the supply amount for Plant 2 and what does it mean?

d-what is the range of feasibility for the demand amount for customer 2 and what does it mean?

Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. Therefore, it is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 1.5 days.

Average number of payments per day 860

Average value of payment $ 810

Variable lockbox fee (per transaction) $ .15

Annual interest rate on money market securities 4.8 %

What is the NPV of the new lockbox system?

b. Suppose in addition to the variable charge that there is an annual fixed charge of $5,000 to be paid at the end of each year. What is the NPV now?

*Most answers from this on Chegg are wrong so I need the correct answer*

Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. Therefore, it is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 1.5 days. Average number of payments per day 700 Average value of payment $ 650 Variable lockbox fee (per transaction) $ .10 Annual interest rate on money market securities 4.1 % a. What is the NPV of the new lockbox system? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Suppose in addition to the variable charge that there is an annual fixed charge of $3,000 to be paid at the end of each year. What is the NPV now?

A new company is planning to build a new database system for holding information about customers and salesmen. ‘Customers’, ‘Salesmen’ and ‘Customers_Salesmen’ are part of the information that the new company wants to store in the new database. These tables are shown below in figure 1, figure 2 and figure 3. The new company intends to use MySQL for building the new database.

Figure 1: Customers table

Figure 2: Salesmen table

Figure 3: Customers_Salesmen table

Based on the above three tables, answer the following 6 questions:

1. Write an SQL statement for creating the customer table that is shown in figure 2. No need to write any SQL statement for adding any record to the customer table.  
2. Write an SQL statement for adding one record to the customer table that was created in question-1 above. The added record should be one of the records that are given in the customer table.   
3. Write an SQL statement to list the information of salesmen who work in Paris.
4. Write an SQL statement to list all customer names who work with the salesman whose id is 5001.                                                                                                                           \
5. Write an SQL statement to list all customer names who work with the salesman whose commission is 0.13.                                                                                                          ]
6. Write an SQL statement to increase the salesman commission by 5%.

1. Cost curve estimation.  You and a group of 9 investors are interested in opening up a relatively large wholesale craft brewery operation to sell and ship specialty beers via the internet. Customers are primarily bars and restaurants. Part of your business plan involves assessing them most cost-efficient volume of beer to produce and distribute each year. To this end, you contacted several brewers associations, consulted with experts in the business, reviewed trade journals and collected estimates of total expenditures for a large set of breweries across the United States and Canada. These data are reported in column’s A and B of the “beer production costs” spreadsheet ( see below).   Q1: Use this data to estimate a cost curve and then Put your regression results in cell H2.

select all true statements about secondary markets:

Question 3 options:

2. Which one of the following foreign bonds is the actual name of bonds that are traded in the U.S.?

a. Bulldog bond

b. Shogun bond

c. Take-your-money-and-run bond

d. Yankee bond

e. All of the above

f. None of the above

3. How much are you willing to pay for a zero that matures in 10 years, has a face value of $1,000 and your required rate of return is 7%? Round to the nearest cent. Do not include a dollar sign in your answer. (i.e. If your answer is $432.51, then type 432.51 without $ sign)

The current stock price is $65 and it will pay $3 dividends in 1 month and 4 months. A European at-the-money put option with 5 months to maturity is traded for $6.A European at-the-money call option with 5 months to maturity is $5. The spot rate for 1, 4, 5 months are 13%,11% and9.5%(c.c).

1.Is there an arbitrage opportunity? If yes describe the investment strategy that pays off today and has for sure zero cash flows at any time in the future.

2.What level in the interest rate ensures that markets are arbitrage free?

A firm has an excess cash flow of $4.8m. It had 3m shares outstanding and was considering paying a cash dividend, corresponding to a 40% payout. The stock traded in the market at $88.00 per share. Assume that the average investor holds 156 shares of the company’s stock.

Note: The term “k” is used to represent thousands (× $1,000).

Required: What would be the average portfolio value after a re-purchase scenario?

$Answerk Do not round intermediate calculations. Input your answer in thousands ($k) rounded to 3 decimal places (for example: 28.31k).