21. Please solve in Excel; round to 3 decimal places.

Company A has a single bond issue American bond (American bonds pay out interest semiannually); the bond has a 6.5% coupon, 9 years to maturity, trades at $1245 per $1000 face value with a face value of $600,000. The cost of equity of 11%, cost of preferred stock of 8%. The company has 120,000 shares of common stock outstanding selling at $30 per share. It has 50,000 shares of preferred stock outstanding selling at $25 per share. The tax rate is 30%.

What is Company A's WACC (please solve in Excel)?

Welcome to Desire, Inc! You have just been hired as the managerial account for the newly formed Desire, Inc. Desire will begin operations on October 1st, Year 1 (i.e., they did not exist before this date). Desire is a merchandising company that retails sporting goods. Your job is to prepare a master budget for Desire for the quarter consisting of October, November, and December Year 1. As part of the budgeting process, you will need to complete the following budget schedules for each of the three months of the quarter:

a. Sales Budget

b. Schedule of Cash Receipts

c. Inventory Purchases Budget

d. Schedule of Cash Payments for Inventory Purchases

e. Selling and Administrative Expense Budget

f. Schedule of Cash Payments for Selling and Admin. Expenses

g. Cash Budget

h. Pro-forma Income Statement

i. Pro-forma Balance Sheet

The following budget information and assumptions will help you complete this task

. • Desire anticipates total sales to be $295,000 for October. o 40% of sales made each month are cash sales. The rest of sales are made on account (Accounts Receivable). o Total sales are expected to increase each month by 17%. o Cash from cash sales is collected immediately (in the month of the sale). All cash from sales made on account is collected in the month following the sale. o Desire predicts that total sales in January of Year 2 will be $246,000. • Desire anticipates Cost of Goods Sold for each month to be 72% of total sales for that month. o Desire requires that ending inventory for each month be 20% of the next month’s expected cost of goods sold. o Because Desire is set to begin operations on October 1st, they did not have any beginning inventory at the beginning of October. o Desire makes all their inventory purchases on account. They will pay for 35% of inventory purchases in the month of purchase, and they will pay for the rest (65%) in the month following the purchase. • Selling and Administrative Expenses are as follows: o Total salaries expense is $25,000 each month, and Desire pays this expense in the month it is incurred o Desire has a sales commission expense equal to 3% of total sales for the month. They do not pay their salespeople the commission until the month following when the sales are made. o Supplies expense is 2% of total sales for the month and is paid for in the month of the sale. o Utilities expense is expected to be $2,250 each month. Utilities are not paid until the month after the expense is incurred. o Depreciation on store fixtures (purchase details described later) is on a straight-line basis and will be $8,375 each month. o Rent on the store is $8,500 each month and is paid in the month it is incurred. o Miscellaneous expenses are $1,500 each month and are paid in the month they are incurred. • Extra notes on the cash budget o Because Desire is set to begin operations on October 1st, they had no beginning cash balance at the beginning of October. o On October 1st , Desire, Inc. collected $265,000 and issued stock to the owners. o On October 1st , Desire purchased $450,000 worth of store fixtures (depreciation on the fixtures was described previously). o Desire declared and paid a $32,000 cash dividend to stockholders on December 31st , Year 1. o Desire has a policy that requires each month’s ending cash balance to be at least $22,000. Desire’s bank requires them to borrow and repay money in increments of $1000. When Desire borrows or repays money, they do so on the last day of the month. If Desire borrows money, they will pay back as much possible in the months when they exceed the $22,000 cash balance minimum. o The bank charges Desire interest of 1% per month (non-compounding). Desire pays the interest at the end of each month when interest is incurred.

Briefly explain how the US came to be dominated by large, centralized AC power systems. Be sure to mention the 2 major decisions that were made early on (one was technological, the other was about the business model used).

Health Maintenance Organizations (HMO) came about in the early 1980’s. Define HMOs, what they were intended to achieve, the reaction by Hospitals, patients and physicians as well as the outcome and whether HMOs were considered a success.

Identify the deprecation methods and which depreciation method would be most useful for a company that wants to match more of the cost of the asset with revenues generated from the asset in the early years of asset use.

Mr Han owes to Saigon Logistics of RM2,000. Upon early settlement of his debt to Saigon Logistics, the company only demanded RM1,800 for payment. Hence, in the book of Saigon Logistics, the difference of RM200 shall be recognised as ______

Does your community have mechanisms in place for early detection of a potential bombing and the infrastructure to mitigate loss of life during and after an event? What are the reporting procedures? Have they been practiced or drilled in your community?

What organic compounds were produced in the Miller-Urey experiment? How did the design of the experiment support the hypothesis that organic compounds are likely to have arisen from abiotic materials present in the atmosphere of early Earth?