{"id":119568,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/i-need-this-excel-work-in-5-hours-or-less-kindly-no-trial-and-error"},"modified":"2017-08-12T07:02:15","modified_gmt":"2017-08-12T07:02:15","slug":"i-need-this-excel-work-in-5-hours-or-less-kindly-no-trial-and-error","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/i-need-this-excel-work-in-5-hours-or-less-kindly-no-trial-and-error\/","title":{"rendered":"I need this excel work in 5 hours or less &#8211; Kindly no trial and error"},"content":{"rendered":"<p>&nbsp;Attached are Balance Sheets and Income Statements for years 0 and 1 for the Alpine Lemonade Co.<\/p>\n<p>Year 0 is the last historical year and Year 1 is a projection year (pro forma).<\/p>\n<p>a.<b>If the tax rate is 40%, what is Alpine&#8217;s Free Cash Flow for year 1?<\/b><\/p>\n<p>b.&nbsp;In addition please answer the following questionsQuestion 1&nbsp;How much is the Net Working Capital in Year 0?&nbsp; &nbsp; &nbsp; &nbsp; 112&nbsp; &nbsp; &nbsp; &nbsp; 132&nbsp; &nbsp; &nbsp; &nbsp; 198Question 2 1 ptsHow much is the Net Working Capital in Year 1?Question 3 1 ptsFrom Year 0 to Year 1, the Net Working Capital increased. Did that have:&nbsp; &nbsp; &nbsp; &nbsp; A positive impact on cash&nbsp; &nbsp; &nbsp; &nbsp; A negative impact on cash&nbsp; &nbsp; &nbsp; &nbsp; No impact on cashQuestion 4 1 ptsThe amount of money spent by Alpine during year 1 to purchase additional Property, Plant &amp; Equipment is equal to:&nbsp; &nbsp; &nbsp; &nbsp; The total value of its Fixed Assets at the end of Year 1: 415.&nbsp; &nbsp; &nbsp; &nbsp; The total value of its Net Fixed Assets at the end of Year 1: 305.&nbsp; &nbsp; &nbsp; &nbsp; The increase in its Fixed Assets from year 0 to year 1: 415 &#8211; 360 = 55.&nbsp; &nbsp; &nbsp; &nbsp; The increase in its Net Fixed Assets from year 0 to year 1: 305 &#8211; 280 = 25.Question 5 1 ptsHow much is the Depreciation expense in year 1?&nbsp; &nbsp; &nbsp; &nbsp; 25&nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; 55Question 6 1 ptsHow much is the Free Cash Flow generated by Alpine in Year 1?Question 7 1 ptsThe future Free Cash Flows of a company will help us value:&nbsp; &nbsp; &nbsp; &nbsp; Its operating assets&nbsp; &nbsp; &nbsp; &nbsp; Its non-operating assets&nbsp; &nbsp; &nbsp; &nbsp; Its equity&nbsp; &nbsp; &nbsp; &nbsp; Its debt&nbsp; &nbsp; &nbsp; &nbsp; Its total balance sheetQuestion 8 1 ptsWhat is the right question to ask in order to value the equity of a company?&nbsp; &nbsp; &nbsp; &nbsp; What are the cash flows the company operations are going to generate?&nbsp; &nbsp; &nbsp; &nbsp; What is the market value of the non-operating assets the company holds?&nbsp; &nbsp; &nbsp; &nbsp; What are the cash flows the shareholders of the company are going to receive?Question 9 1 ptsAssume a company plans to have Earnings per share of $10 next year and plans to reinvest 40% of them at an annual rate of 24% in perpetuity.Assume also the discount rate is 10%.How much is the value of equity?&nbsp; &nbsp; &nbsp; &nbsp; 150&nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; 1500Question 10 1 ptsWhich statement do you agree with?Growth can destroy value when:&nbsp; &nbsp; &nbsp; &nbsp; The retained earnings are invested at a higher rate than the discount rate.&nbsp; &nbsp; &nbsp; &nbsp; The retained earnings are invested at a lower rate than the discount rate.&nbsp; &nbsp; &nbsp; &nbsp; The retention rate is higher than the discount rate.&nbsp; &nbsp; &nbsp; &nbsp; The retention rate is lower than the discount rate.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;Attached are Balance Sheets and Income Statements for years 0 and 1 for the Alpine Lemonade Co. Year 0 is the last historical year and Year 1 is a projection year (pro forma). a.If the tax rate is 40%, what <a href=\"https:\/\/www.benedictsol.com\/blogs\/i-need-this-excel-work-in-5-hours-or-less-kindly-no-trial-and-error\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-119568","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/119568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=119568"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/119568\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=119568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=119568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=119568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}