Excel Project 2 IFSM

Please help with Part B

Study Excel Instructio x EXAM 3-BUSI 320 class notes x b Login (bartieby es/155996/assignments/1958552 E Individual Differen... M Corporate Finance U SPAN101: Element... L Canvas Dashboard U Course Registration out # 4 Comp Prob - Ch 12 (D).docx I Downle Case Study # 4 Excel Submission – Capital Budgeting Comprehensive Problem Pinnacle Custom Home Builders purchased a 40 foot articulating boom lift three years ago for $50,000. The equipment has been depreciated under the 5-year MACRS schedule (20%, 32%, 19%, 12%, 12% & 5%). The old equipment can be sold for $33,000. Pinnacle is considering the purchase of a new 60 foot articulating boom lift that would allow the company to complete nearly all of its construction projects without the need for costly rental lifts. The new lift could be purchased for $105,000 and would also fall under the 5-year MACRS depreciation schedule. Assume the old and new equipment would provide the following operating gains (or losses) over the next six years.…

P 00 it View History Bookmarks Window Help 00 A ezto.mheducation.com nt Portal Course Modules: Budgeting and Forecasting 62211 Week 4: Homework Question 3 - Week 4: Homework - Co omework G Saved Help Save & Exit Submit Check my work Information pertaining to Noskey Corporation's sales revenue follows: November 2021 (Actual) $ 180,000 December 2021 (Budgeted) $ 160,000 500,000 January 2022 (Budgeted) Cash sales 000'09 $ 540,000 Credit sales $ 360,000 000'09 Total sales 000'099 2$ Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next month's projected total sales (stated at cost) plus 30% of projected sales for the current month (stated at cost). All inventory purchases are on-account; 25% is paid in the month of purchase, and the remainder is paid in the month following the month of purchase.…

< + .. + Sheet1 FINA310 IP TEMPLATE FOR STUDENTS Student name: Date: ACTUAL FORECAST Current Year Next Year Total Revenue 71,879 Cost of Revenue (51,125) Gross Profit 20,754 Operating Expenses: Selling, General, and Administrative (14,248) Research and Development Special Income/Other Charges S (2,194) Total Operating Expenses (16,442) Operating Income S 4,312 Net Interest Income (666) edite Pre-Tax Income 3,646 Provision for Income Tax (19.5%) (711) Net Income 2,935

Help please with right answer

What is the amount of the total paid-in capital? What makes up this amount?

FINA310 IP TEMPLATE FOR STUDENTS Student name: Date: ACTUAL FORECAST Current Year Next Year Total Revenue 71,879 |Cost of Revenue (51,125) Gross Profit 20,754 Operating Expenses: Selling, General, and Administrative (14,248) Research and Development Special Income/Other Charges (2,194) Total Operating Expenses (16,442) Operating Income 4,312 Net Interest Income (666) edite Pre-Tax Income 3,646 Provision for Income Tax (19.5%) (711) Net Income 2,935 Additionally, Tag-It's CEO has predicted a 12% increase in total revenue next year. Utilizing the percentage of sales method, prepare a forecast for next year in the correct section on the Excel spreadsheet. 1. The total revenue numbers over the past 4 years for Tag-lt Corporation were as follows (values in millions): o 73,785 O 69,495 o 75,356 o 71,879 2. Determine whether you think Tag-It can hit the target of a 12% increase in sales next year.

own): Week 31 x CU122-0 2201 (Brown): Week 4 x Week 6: Culmination Knowledge x npt.php?attempt=D29214128cmid=866335 fr. E Enduring Word Bibl. b My Questions | bart. Financial Aid Student Accounts Resources - Campus Store g and Cost Control 2202-DeWitt s/ CE167-0 2202 (DeWitt)/ Week 6: Menu Prices Week 6: Culmination Knowledge Check Chef Amy does beginning inventory on Thursday night and finds that she has $4194 in food products in the restaurant. Throughout the week she purchases: • $2088 produce, • $1678 protein, • $870 dry goods, and • $3914 dairy. The following Thursday she does ending inventory and finds that she has $3464 in food. She looks at her sales and finds that she made $30541 over the same 7 day period. What is her total food cost? Select one: a. $12,744 K b. $16,208 c. $8,550 d. $9,280 Chef Fabio does beginning inventory on Thursday night and finds that he has $1456 in food products in the restaurant,. Throughout the week he ered purchases: 1.00 • $457 produce, • $632…

Sheffield Corp. uses the percentage-of-receivables basis to record bad debt expense and concludes that 3% of accounts receivable will become uncollectible. Accounts receivable are $430,800 at the end of the year, and the allowance for doubtful accounts has a credit balance of $2,864. (a) Prepare the adjusting journal entry to record bad debt expense for the year. (b) If the allowance for doubtful accounts had a debit balance of $887 instead of a credit balance of $2,864, prepare the adjusting journal entry for bad debt expense.

dget and Foreca x + empt.php?attempt=2891395&cmid=866300 LA fr. A Enduring Word Bibl. My Questions | bart. Financial Aid Student Accounts Resources- Campus Store Weekly (Feb 21-27) Projected Actual Difference Food Cost $6,971 $7,842 +$871 (over) Beverage Cost $3,954 $4,156 +$202 (over) Labor Cost $8,423 $9,541 +$1,118 (over) Other Costs $7,645 $7,645 $0 (even) Total Costs $26,993 $29,184 +$2191 (over) Food Sales $18,565 $14,326 -$4,239 (under) Beverage Sales $12,872 $10,852 -$2,020 (under) Total Sales (Revenue) $31,437 $25,178 $6,259 (under) Total Profit $4,444 -$4,006 $8.450 (under) Based on the actual results, what adjustments need to be made to Food and Beverage costs? Select one: a. Food and Beverage costs do not need to be adjusted because it will balance out next week. b. Food and Beverage costs need to be reduced by purchasing cheaper products, reducing waste, and/or reducing portion size. O c. Food and Beverage costs need to be increased by purchasing higher quality…

B ch01 (Fall 2021 w https://education.wiley. B Present Value Tables (1. Final Exam (Fall 2020) - Final Exam (Fall 2020) -/6 Question 24 of 50 View Policies Current Attempt in Progress Sheridan Manufacturing Company expects the following sales in January, February, and March: Cash Credit Sales Sales $50900 $250500 January February $45900 $240500 March $85000 $325000 The controller has determined that the company collects credit sales as follows: 60% in the month of sale, 30% in the first month after sale, 5% in the second month after sale, and 5% is expected to be uncollectible. How much cash will be collected from customers in March? O $352150 O $364675 O $410000 O $279675 Save for Later Attempts: 0 of 1 used Submit Answer MacBook Air esc 888 FT F2 F3 F4 F5 F6 F7 F8 @ # 2$ 4 & * 6. 7 8. Q W

blem Set: ModX * CengageNOWv2 | On x * Cengage Learning B Milestone Two Guidel x G module 5 problem set X ow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=. Lo еВook Show Me How Entries for notes payable Bennett Enterprises issues a $660,000, 45-day, 9%, note to Spectrum Industries for merchandise inventory. Assume a 360-day year. If required, round your answers to the nearest dollar.If an amount box does not require an entry, leave it blank. a. Journalize Bennett Enterprises' entries to record: 1. the issuance of the note. 2. the payment of the note at maturity. 2 b. Journalize Spectrum Industries' entries to record: 1. the receipt of the note. 2. the receipt of the payment of the note at maturity. Previous Check My Work 56°F Mostly cloudy ヘ 回。

about:blank Blackboard Learn sc.edu/webapps/assessment/take/launch isp?course assessment_id=_114 Remaining Time: 1 hour, 23 minutes, 35 seconds. Question Completion Status: A Moving to the next question prevents changes to this answer. Question 1 What is the Payback Period for the following investment? Year 1 2 3 4 5 O a. 3.77 Ob. 3.73 Oc. 3.89 Od. 3.96 Cash Out $ (1,600,000) (710,000) Cash In 550,000 580,000 610,000 640,000 670,000 A Moving to the next question prevents changes to this answer. 000 900 F2 F3 F4 MacBook

Course: 2020FA Accounting for X * CengageNOWv2 | Online teachir x /v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAs... еВook GE Calculator Sales Mix and Break-Even Sales Data related to the expected sales of kayaks and canoes for River Sports Inc. for the current year, which is typical of recent years, are as follows: Products Unit Selling Price Unit Variable Cost Sales Mix Kayaks $240 $160 20% Canoes 510 240 80% The estimated fixed costs for the current year are $273,760. Instructions: 1. Determine the estimated units of sales of the overall product necessary to reach the break-even point for the current year. units 2. Based on the break-even sales (units) in part (1), determine the unit sales of both kayaks and canoes for the current year. Kayaks units Canoes units 3. Assume that the sales mix was 80% Kayaks and 20% canoes. Determine the estimated units of sales of the overall product necessary to reach the break-even point for the current year. units 田

Unauthorized My Home CengageNOWv2 | Online teachin × + https://v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogres. Chapter 20 еBook Show Me How Contribution Margin Ratio a. Young Company budgets sales of $112,900,000, fixed costs of $25,000,000, and variable costs of $66,611,000. What is the contribution margin ratio for Young Company? % b. If the contribution margin ratio for Martinez Company is 40%, sales were $34,800,000, and fixed costs were $1,500,000, what was the operating income? $4 6:39 PM 63°F 11/5/2021

plem Set: Mod x * CengageNOW2| On x * Cengage Learning B Milestone Two Guidel x G module 5 problem se x+ ow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogres.. еBook Show Me How Determining Cost of Land On-Time Delivery Company acquired an adjacent lot to construct a new warehouse, paying $44,000 in cash and giving a short-term note for $272,000. Legal fees paid were $1,780, delinquent taxes assumed were $14,700, and fees paid to remove an old building from the land were $21,700. Materials salvaged from the demolition of the building were sold for $4,700. A contractor was paid $960,600 to construct a new warehouse. Determine the cost of the land to be reported on the balance sheet. Next Previous 3:20 PM Check My Work 11/28/2021 56 F

V Content Pearson (Assignments) - MA Ô https://www.mathxl.com/Student/PlayerTest.aspx?testld%3D225147196 3 103 Spring 2021 st: Test 2 (Finance) Online nis Question: 1 pt 5 of 19 (1 complete) ▼ How much must be deposited today into the following account in order to have a $135,000 college fund in 11 years? Assume no additional deposits are made. An account with quarterly compounding and an APR of 7.32% Sshould be deposited today. (Do not round until the final answer. Then round to the nearest cent as needed.)

Need the sub-part for questions D-F!

ccounting | Spring 2023 uiz Course Home - kar X K Chapter 9 Quiz OA. $18,200 OB. $18,800 OC. $17,500 O D. $20,300 mylab.pearson.com Question 5 of 10 X G At year-end, Snow 0 4 kara harper 04/09/23 10:36 AM This quiz: 10 point(s) possible This question: 1 point(s) possible ? Submit quiz Buddy Company uses the allowance method to account for uncollectible receivables. At the beginning of the year, Allowance for Bad Debts had a credit balance of $800. During the year Buddy wrote off uncollectible receivables of $2,100. Buddy recorded Bad Debts Expense of $2,800. Buddy's year-end balance in Allowance for Bad Debts is $1,500. Buddy's ending balance of Accounts Receivable is $20,300. Compute the net realizable value of Accounts Receivable at year-end.

What is the answer A thru D?

Find the NPV using 11% discount Year 0-3, Project A, B

&external_browser%3D0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-group ter 8 homework i Saved Help Save & Exit Sub Check my wor Samuelson and Messenger (SAM) began 2021 with 200 units of its one product. These units were purchased near the end of 2020 for $25 each. During the month of January, 100 units were purchased on January 8 for $28 each and another 200 units were purchased on January 19 for $30 each. Sales of 125 units and 100 units were made on January 10 and January 25, respectively. There were 275 units on hand at the end of the month. SAM uses a periodic inventory system. Required: 1. Calculate ending inventory and cost of goods sold for January using FIFO. 2. Calculate ending inventory and cost of goods sold for January using average cost. oped Complete this question by entering your answers in the tabs below. ook Required 1 Required 2 rint Calculate ending inventory and cost of goods sold for January using FIFO. rences Cost of Goods…

FunTime Cruiseline offers nightly dinner cruises departing from several cities on the east- ern coast of the United States including Charleston, Baltimore, and Alexandria. Dinner cruise tickets sell for $50 per passenger. FunTime Cruiseline's variable cost of providing the dinner is $30 per passenger, and the fixed cost of operating the vessels (depreciation, salaries, docking fees, and other expenses) is $210,000 per month. The company's rel- evant range extends to 20,000 monthly passengers.

Live Class Wed January 27, 2021 x 9 Dashboard x + - edugen.wileyplus.com/edugen/student/mainfr.uni en Assignment + * 引 CALCULATOR FULL SCREEN PRINTER VERSION 4 ВАСK NEX OURCES Exercise 1-14 (Part Level Submission) g 2021 Cheyenne Corp., a public camping ground near the Four Corners National Recreation Area, has compiled the following financial information as of December 31, 2019. Revenues during 2019-camping fees $190,400 Notes payable $81,600 1-4 Revenues during 2019-general store 63,920 Expenses during 2019 204,000 1-5 1-6 Accounts payable 14,960 Supplies on hand 3,400 Cash on hand 27,200 Common stock 27,200 Original cost of equipment 143,480 Retained earnings ? 1-8 e1-9 e 1-11 w14 v 1-5 Fair value of equipment 190,400 v (a) Your answer is correct. Determine Cheyenne Corp.'s net income for 2019. 11 14 (Part mission) Cheyenne Corp.'s net income 50320 -4A (Part mission) SHOW LIST OF ACCOUNTS SHOW SOLUTION SHOW ANSWER re Eults by Study LINK TO TEXT VIDEO: SIMILAR EXERCISE Attempts: 1 of…