a. Create & tak tu shown above. Your spreadsheet should then calculate the margi

Question

a. Create & tak tu shown above. Your spreadsheet should then calculate the marginal tax ralé, the average tax rate, and the tax bill for any level of taxable income input by a user b. For a taxable income of $1,350,000, what is the marginal tax rate? c. For a taxable income of $1,350,000, what is the total tax bill? d. For a taxable income of $1,350,000, what is the average tax rate? MINICASE Cash Flows and Financial Statements at Sunset Boards, Inc. Sunset Boards is a small company that manufactures and sells After rooting through old bank statements, sales receipts. surfboards in Malibu. Tad Marks, the founder of the company. tax returns, and other records, Christina has assembled the in charge of the design and sale of the surfboards, but his following information background is in surfing, not business. As a result, the compa- ny's financial records are not well maintained. The initial investment in Sunset Boards was provided by Tad and his friends and family. Because the initial investment was relatively small, and the company has made surfboards Cost of goods sold only for its own store, the investors haven't required detailed Cash financial statements from Tad. But thanks to word of mouth among professional surfers, sales have picked up recently, andInterest expense Tad is considering a major expansion. His plans include open- ing another surfboard store in Hawaii, as well as supplying his sticks (surfer lingo for boards) to other sellers. 2017 2018 $322,742 55,725 $255,605 36,884 72.158 15,687 81,559 17.980 65,610 44.318 387,855 611.224 33.901 32.441 Selling and administratve Tad's expansion plans require a significant investment.Net fxed assets which he plans to finance with a combination of additional Sales funds from outsiders plus some money borrowed from banks. Accounts recelivable Naturally, the new investors and creditors require more orga-Notes payable nized and detailed financial statements than Tad has previously 26,186 318.345 501.441 26136 29,712 160,689 50.318 prepared. At the urging of his investors, Tad has hired finan nve cial analyst Christina Wolfe to evaluate the performance of the Inventory New equity 175.340 67,674 19.500 company over the past year

Explanation / Answer

In my opinion Tads expansion plans would be the best for multiple reasons. First off being the cash flow for his investing activities were hardly covered by his financing cash flow and operating cash flow, because of this he will need a lot of outside funds to finance and operate this expansion. Because of all of the issues at hand I don’t really think an investment would be worth it. An investor would usually need more information about how the capital spending would be necessary, also how much the OCFs would get from this investments. I don’t think this would be a good idea.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.