chapter 12 Create an Excel spreadsheet to organize your answers to the...
60.1K
Verified Solution
Link Copied!
Question
Accounting
chapter 12
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page.
A company with annual sales of $22,000,000 is considering changing its payment terms from net 40 to net 30 to encourage customers to pay more promptly. The company forecasts that customers would respond by paying on day 32 rather than day 44 as at present (assume a 360 day year) but would decrease their purchases by $400,000 per year. The company also forecasts that its idle cash balance would decrease by $80,000 and administrative costs would be reduced by $30,000 per year. The company's variable costs average 62% of sales, it is in the 35% marginal tax bracket, and it has an 8% cost of capital.
Part A: Calculate the incremental cash flows from accepting this proposal, and organize your cash flows into a cash flow spreadsheet.
Part B: Calculate the proposal's NPV, IRR, and NAB.
Part C: Should the company shorten its payment terms?
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page.
A company with annual sales of $22,000,000 is considering changing its payment terms from net 40 to net 30 to encourage customers to pay more promptly. The company forecasts that customers would respond by paying on day 32 rather than day 44 as at present (assume a 360 day year) but would decrease their purchases by $400,000 per year. The company also forecasts that its idle cash balance would decrease by $80,000 and administrative costs would be reduced by $30,000 per year. The company's variable costs average 62% of sales, it is in the 35% marginal tax bracket, and it has an 8% cost of capital.
Part A: Calculate the incremental cash flows from accepting this proposal, and organize your cash flows into a cash flow spreadsheet.
Part B: Calculate the proposal's NPV, IRR, and NAB.
Part C: Should the company shorten its payment terms?
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.