Question: please I need the answer on the Excel sheet I have hour left Suppose that you just purchased 300 shares of Beta Banana's stock for

please I need the answer on the Excel sheet I have hour left

Suppose that you just purchased 300 shares of Beta Banana's stock for $80 per share. The initial margin requirement is 60.0%, which means the amount borrowed is $9,600. The corresponding balance sheet is below: Assets Liabilities and Equity Stock $ 24,000.00 Loan from broker $ 9,500.00 Equity $ 14,400.00 Total assets $ 24,000.00 Total liabilities and equity $ 24,000.00 Required: a. Now suppose the price of the stock falls to $49 per share. What is your current margin percentage? (Round your answer to 2 decimal places.) Margin percentage b. Construct the balance sheet to show the current situation. Assets Stock Liabilities and Equity Loan from broker Equity Total liabilities and equity Total assets c. If the maintenance margin is 60%, ot what stock price would you get a margin coll? (Round your answer to 2 decimal places.) Prion

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

You should lease rather than buy whes the DI NAL from leasing is poaitive. IRR bei leaing exceeds the afeux oest of borrowing. m) Which ene of these is considered to be the best reason for obtaising...

Please see the attached. These questions are pretty repetitive. I don't need solutions... I just need answers. Thank you. 1. What is the value of a bond that has a par value of $1,000, a coupon rate...

just need answer 1. A bond matures in 14 years at $1,000. The bond has a coupon of 4% and makes semiannual payments. The bond currently sells for $1,037 and is callable in 5 years at a special price...

please answer question e,f,g,h Additional information you may find useful: The current market price of ESS's securities: common stock = $47.50 per share; preferred shares = $44 per share and their...

1. A bond matures in 14 years at $1,000. The bond has a coupon of 4% and makes semi-annual payments. The bond currently sells for $1,037 and is callable in 5 years at a special price of $1,020. What...

please please help Question 13 13 p Use the following information to answer questions 13 and 14: You purchased 300 shares of ABC common stock on margin at $80 per share. Assume the initial margin is...

Angelo is getting ready to prepare his 2023 tax return. Please analyze each line item below, and input the related tax income or deduction onto the tax income workpaper. You will need to add your...

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

I wanted to ask a question regarding questions 12 and 13, under section 16.4 of the file I uploaded. In question 12, we had to calculate the value of the firm without leverage. In question 13 we had...

Please provide excel spreadsheet detailing how you got to the multiple choice answer. I am trying to get ahead and understand each of the practiceproblems in prep for a exam so it would be very...

1. What values do you have as an individual? Which is most important to you and why? 2. Where do your values come from? 3. What values would be important to have as a human service worker or chemical...

The organizational structure of a manufacturing company includes the following departments: purchasing, receiving, inspecting, warehousing, and controllership. An auditor is assigned to audit the...

Benchmark risk: Multiple Choice is inevitable and is always a significant issue in practice. cannot be constrained to keep a Treynor - Black portfolio within reasonable weights. is inevitable and is...

Drexel Co. has a price variance of $5,000 (U) and a quantity variance of $4,000 (F) for raw materials. Given that the actual costs for raw material are $40,000, what are the standard costs of raw...